not equal to in QVD generator

[#1]

SQL

SELECT

*
FROM PUB.invanal

where analysis-cat not in('d','c','f');

When I use this, its removing the records with blank values also.

Is there any way to avoid it?

[stevedark · Accepted solution]

Hi Nick,

Are you sure it is blank values, not NULLs?

You could try the following:

WHERE (analysis-cat IS NULL OR analysis-cat NOT IN ('d','c','f'));

Hope that helps,

Steve