That is incorrect. You can insert an empty date with '' which will show as '1/1/1900' and obtain a result set that contains such records with the statement on my previous reply. This is the way it works in 6.5 and 7.0, haven't tested on SQL 2000 though.
>Hi just one thing this will allways return an empty cursor since in SQL server there are not such things as an empty date dates will have some value our will be null never empty.
>
>>>Can anyone recommend a good solution for displaying and detecting empty dates in SQL Server (which are returned as 1/1/1900 12:00 AM)?
>>>
>>>Thanks.
>>
>>Joel,
>>
>>If you already have empty dates that show 1/1/1900 you can check for those with '' as in
>>
Select * From myTable Where myDateField=''
>>HTH