>I added a field of type Tinyint (which will be used as logical .T./.F. in VFP app) to an existing table. When I retrieve a bunch of records, all existing records have value .T.. In SQL Server table they are all .NULL. I am thinking about deleting this field and entering it again to make all existing records to be value .F.. How would I do it? That is, when I add a new field to the SQL Server table, what should I do to make the existing fields 0 and not .NULL.?
You can specify DEFAULT for the column to be 0.
--sb--