0 votes
1 view
in SQL by (20.3k points)

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 

1 Answer

0 votes
by (40.4k points)

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

Related questions

+2 votes
1 answer
0 votes
1 answer
0 votes
1 answer
+2 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...