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
Alexandre Palma
Senior Application Architect