Tom,

The query should be as follows:

SELECT * FROM MyTable WHERE MyDate IS NULL

Null is a special value that isn't equal to anything. Values either are or are not null (IS NULL or IS NOT NULL).

HTH,
Chad


>I have date fields that have null values. I wish to return a data set of records of this type.
>
>

>SELECT * FROM MyTable WHERE MyDate = NULL
>

>
>This does not error out but it returns no values. Any suggestions?
>
>Thank you
>
>Tom