How to select on ISNULL

[Former Member]

I Have this datetime col. I want to show rows that has a date of NULL in that col.

WHen I use 

where Mydate ISNULL and

etc.

I get an error, remaining is not part of the formula.

How can I select on a column which is NULL value?

[DellSC · Accepted solution]

If you're doing this in a command, you need to put a space between IS and Null - so it would be:

where Mydate is null

If you're doing this in the Select Expert, it needs to be this:

IsNull({MyTable.MyDate})

-Dell