Hi Bret,
The preferable way to deal with empty dates is to convert them to Nulls. The alternative is to store dates as character strings in SQL Server.
>We are currently trying to convert a VFP database to SQL server using the wizards on SQL Server. THe problem we see is that SQL Server does not like empty date fields. Is the a way to get around this? We have quite a few tables where there is nothing in the date field.
>
>As a side question, does anyone have any other conversion pitfall tips I may need? So far I see the Empty date and a numeric field where VFP allowed data in but SQL states it has problems.
>
>Any help would be appreciated.
--sb--