sql - SQL Server：CASE WHEN OREN ELSE END =>不支持OR(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.

(不支持CASE语句的WHEN子句中的OR 。)

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 

  ask by Werner translate from so

Answer 1

That format requires you to use either:

(该格式要求您使用以下任一种：)

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 

Otherwise, use:

(否则，使用：)

CASE  
  WHEN ebv.db_no IN (22978, 23218, 23219) THEN 'WECS 9500' 
  ELSE 'WECS 9520' 
END as wecs_system