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