CODEWITHSUNDEEP
sql-servercase-when
Orion
Orion

Reputation: 3

CASE WHEN With multiple

I have a statement that is working:

CASE [Level 1]
WHEN '2017' THEN ''
WHEN '2016' THEN '' 
WHEN '2015' THEN ''
WHEN '2014' THEN ''
ELSE [Level 1]
END

I was trying to do something like this but it doesn't work:

CASE WHEN [LEVEL 1]
LIKE 'CALENDAR MONTH%' THEN 'CALENDAR MONTH'
LIKE 'CALENDAR WEEK%' THEN 'CALENDAR WEEK'
LIKE 'CALENDAR QUARTER%' THEN 'CALENDAR QUARTER'
ELSE '[LEVEL 1]
END

Suggestions on how to make this second statement work?

Upvotes: 0

Views: 32

Answers (1)

pmbAustin
pmbAustin

Reputation: 3970

You want something like this:

  CASE WHEN [LEVEL 1] LIKE 'CALENDAR MONTH%' THEN 'CALENDAR MONTH'
       WHEN [LEVEL 1] LIKE 'CALENDAR WEEK%' THEN 'CALENDAR WEEK'
       WHEN [LEVEL 1] LIKE 'CALENDAR QUARTER%' THEN 'CALENDAR QUARTER'
       ELSE [LEVEL 1]
  END

Upvotes: 1

Related Questions