IN statement in result expression in CASE THEN expression

sql, sql-server, t-sql

Solution

Sorry, no:

WHERE
    (@flag = 1 AND record.field = a)
    OR
    (@flag = 2 AND record.field IN (b, c))

Problem

Is it possible to use `IN` in `CASE..THEN` ? ``` WHERE record.field = CASE WHEN @flag = 1 THEN a WHEN @flag = 2 THEN IN (b, c) END ``` Or how to rewrite such condition?

Original source