SQL Server: CASE WHEN OR THEN ELSE END => the OR is not supported

Question

The OR in the WHEN clause of a CASE statement is not supported. How can I do this?

CASE ebv.db_no 

    WHEN 22978 OR 23218 OR 23219 THEN 'WECS 9500' 

    ELSE 'WECS 9520' 

END as wecs_system 

Answer 1

Use this code:

CASE ebv.db_no 

  WHEN 22978 THEN 'WECS 9500' 

  WHEN 23218 THEN 'WECS 9500'  

  WHEN 23219 THEN 'WECS 9500' 

  ELSE 'WECS 9520' 

END as wecs_system

Or 

CASE  

  WHEN ebv.db_no IN (22978, 23218, 23219) THEN 'WECS 9500' 

  ELSE 'WECS 9520' 

END as wecs_system