I am trying to filter this but the "NOT IN" is erroring out.
WHERE
CASE WHEN Condition1 = 'Hello' THEN Field1 NOT IN ('ABC', 'DEF')
ELSE 1 --SELECT Everything
END = 1
I am trying to filter this but the "NOT IN" is erroring out.
WHERE
CASE WHEN Condition1 = 'Hello' THEN Field1 NOT IN ('ABC', 'DEF')
ELSE 1 --SELECT Everything
END = 1
Nevermind, got it:
WHERE
CASE WHEN Condition1 = 'Hello' THEN
CASE WHEN Field1 IN ('ABC', 'DEF') THEN 0
ELSE 1
END
ELSE 1 --SELECT Everything
END = 1
WHERE
CASE WHEN Condition1 = 'Hello' AND Field1 NOT IN ('ABC', 'DEF')
THEN 0
ELSE 1
END = 1