Case with like operator

Now what error it is giving. You can follow up with this link, https://www.w3schools.com/sql/sql_case.asp

0

Hi,

Use like this (with example)-

DECLARE @temp AS table

( queue_name varchar(10))

insert into @temp values('ADVERB')

insert into @temp values('PPPP')

insert into @temp values('QQQQ')

select case when queue_name like '%P%' then 'ADLEVEL' else 'COMPLEVEL' end as col1 FROM @temp

0

Hi Salman,

I have written the same. Its giving an error.

0

Hi. You need to write like this, select case when queue_name like '%- Ad%' then "ADLEVEL" else "COMPLEVEL" end as col1 FROM table

0

[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