T-SQL SYNTAX ISSUE - Using OR in a CASE Statement

Question

I would like to create a CASE statement that includes the following logic, but the sql compiler does not like "OR" in my statement:

CASE expression WHEN expression1 OR expression2 THEN <yadda yadda> ELSE <yadda yadda> END 

more specific code below:

 CASE @var1 WHEN '99' OR '22' THEN (CASE @var2 WHEN 'All' THEN col1 ELSE @var2 END) END 

Answer 1

 DECLARE @Variable INT; SET @Variable = 1; SELECT CASE WHEN @Variable = 1 OR @Variable = 2 THEN 'It is 1 or 2' WHEN @Variable = 3 THEN 'It is 3' ELSE 'It is not 1, 2, or 3' END AS [SomeField] 

MSDN documents for CASE , OR, and Expression .

Answer 2

According to your changes, you don't even need an OR statement:

 CASE WHEN @var1 IN ('99', '22') THEN (CASE @var2 WHEN 'All' THEN col1 ELSE @var2 END) END