>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