Hi,

I have a report where I need to filter out values that I get in this form: ('value1','value2','value3')

I can use WHERE VALUE IN('value1','value2','value3') when i want to include those values.

But, how about when I want to exclude those values? NOT IN isn't an option it seems.

This message has been edited. Last edited by: Prince Joseph,

Sure it is:
WHERE NOT COLUMN_NAME IN ('VAL0','VAL1','VAL2')

That was it. Thanks for your help!

Welcome.
Merry Christmas!
Tom

Merry Christmas!