>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