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