Hi!

Empty date is not a .NULL. value. It is specific value in VFP. SQL Server do not have such format for date, so all empty dates are replaced by the some predefined date. You can replace these dates by .NULL. values using simple UPDATE-SQL command sent to SQL Serevr:

UPDATE MyTable SET MyDate=null WHERE MyDate='01/01/1900'

In addition, field should allow nulls.

Than in VFP application you will require some changes to handle null dates.

Another solution is to change applciation logic so dates are never empty.

HTH.

>What are the best ways for handling null values after upsizing a database and then using remote views to access it? Specifically, I noticed that empty date fields which used to display as " / / ", are now "01/01/1900". Have I done something wrong (fairly likely, given my experience with SQL Server) or do I write code to handle this, or.....
>
>Thanks,
>Pat