Use of CASE in WHERE

[marcholmes]

It must be possible, because Teradata doesn't complain. It just doesn't return any data.

Here's the code:-

WHERE AIB IN
(CASE WHEN EXTRACT (MONTH FROM DATE) IN (1,4,7,10)
THEN '(A,B)'
ELSE '(I,B)'
END
)

Where am I going wrong?

p.s. yes, I know it can be done with ANDs and ORs, but this has now turned into a challenge.

 

[dnoeth]

The CASE doesn't return a list of values, it's a string.
It's similar to
WHERE AIB = '(A,B)' OR AIB = '(I,B)'

Dieter