IOT Virtual Conference - Register now to book your ticket and get updates
x
CONGRATULATIONS! C# Corner Q1, 2021 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forumguidelines
Sai Reddy
1.8k
212
16.5k
Case with like operator
Sep 19 2019 7:33 AM
I have a column called queue_name with following values.
[Ads] [dddd] Polit Classification US - Ad
add level
[Ads] [dddd] Political Classification US - Ad
add level
[Ads] [Proactive] Political Classification US - Body (Dark Mode)
unknown
if column has - Ad then status as 'add level' else 'unknown'
i tried it as follows.
select (case when queue_name like '%- Ad%' then "ADLEVEL" else "COMPLEVEL" end) FROM table
i got the following error.
Column 'adlevel' cannot be resolved
Reply
Answers (
4
)
How to update ClientCode ?
Database connection sleep awaiting command | open Connection