I imported a FoxPro table into SQLServer 2000 using the import DTS wizard in Enterprise Manager. When I looked at the data in Enterprise Manager the datetime fields that had null values showed "12:00:00 AM". When I did a select * from [tablename] in Query Analyzer the null dates showed "1899-12-30 00:00:00.000". We also have a nother piece of software which shows "12:00:00 AM". Both versions of the table in Fox and SQL allow nulls. What is causing this in the datetime fields?