Actually Michel, I think the '12-30-1899' date is for Foxpro. SQL Server's empty date is '1-1-1900'.

~~Bonnie


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