Chad;

You are correct. I answered my own question just before I opened your answer. Thank you very much.

Tom



>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