TSQL - Case When

Example

• Style 1

CASE ('Expression') 
  WHEN Value1 THEN 'Do something for Value1' 
  WHEN Value2 THEN 'Do something for Value2'
  WHEN Value3 THEN 'Do something for Value3'
  ELSE 'Do something for all other values'
  END 

• Style 2

CASE  
  WHEN 'Expression1' THEN 'Do something for Expression1' 
  WHEN 'Expression2' THEN 'Do something for Expression2' 
  ELSE 'Do something for all other expressions'
END