How to Handle OR Conditions in SQL Server CASE Expressions?

OR Operator Unsupported in CASE Expression

When attempting to utilize the OR operator in the WHEN clause of a CASE expression in SQL Server, one may encounter the error message, "The OR operator in the WHEN clause of a CASE expression is not supported." To address this issue, there are two recommended approaches:

1. Explicit WHEN Clauses:

   • Utilize individual WHEN clauses for each condition, as shown below:

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

2. IN Operator:

   • Employ the IN operator to specify multiple values within a single WHEN clause, as follows:

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

By implementing one of these methods, you can effectively handle the OR condition within the CASE expression and obtain the desired result.

The above is the detailed content of How to Handle OR Conditions in SQL Server CASE Expressions?. For more information, please follow other related articles on the PHP Chinese website!