I have a remote view of a MS SQL Server table. When I upsized the original table VFP changed null values in a date field to 01/01/1900. I have since modified the SQL table to have NULL as the default value for this field.

I am now trying to remove the 01/01/1900 values. However, I'm not having any luck. When I delete the values and requery the view, 01/01/1900 reappears.

This does not happen with MS Query.

Help!

Jeff