>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?

This does not exist in SQL Server. You will have to check for December 30, 1899.