Database load (SQL) with null values

[#1]

Hi all,

I want to load some data from a SQL server database but would like to filter out null values for a specific field. The standard 'is null' statement does not seem to work. Any ideas?

Cheers!

Erik

[nirav_bhimani]

Hi

Try this statement in the script after From Clause

Where len("Category") <> 0;

In place of category write your field name.

Regards,

Nirav Bhimani

[Anonymous]

I also have to do this sort of test of lenght as I've not found a way to test the negative of a IsNull() function. Is tihs accepted practic ?

Jonathan

[#4 · Accepted solution]

That does not seem to work. But after trying again I found that the 'is null' statement does work.

Load

*

where not Field1 is null