The Datetime datatype in SQL Server is stored internally as an integer, where 0 represents so called base date - 1/1/1900. When you cast a blank string to a datetime, that's what you end up with.

You can either treat 1/1/1900 as an empty date or change the column to allow nulls.

Roman

>Im inserting into SQL from Fox using Pass through. Fox has empty Dates {//}. if I use CAST('' AS DATETIME) I get a default datetime 1900-01-01 00:00 ext in SQL. The Date in SQL does not accetp nulls. Can I get SQL to CAST() an empty Date? OR, should I allow SQL date column to accept nulls? I usally allow nulls in cretain columns.
>
>Your input is appreciated.
>Regards
>Jeff Hart