I have a field A and B. I want A to be filterered based a condition
When B= 2 then A should not be in (1,2,3,4)
When B=1 then give me back all of A (no filters)
I am trying to do something like:
Case when B=2 then A Not in (1,2,3,4) else A
How do I incorporate this in my case statement? Or do I need some other way to do this? Please help.
Thanks to all in advance!
View Complete Post