>I am doing a sql select with LEFT OUTER to a child table. If the child table does not have a record in the master table I still get the record returned (that's what I want), but the values for the fields of the child record are filled with nulls. I've tried SET NULL OFF but no luck. The problem is that I am inserting these records into another table that does not allow null values. Is there a way to do this query without returning nulls for those records?
>
>Thanks.
>
>John
John,
Another suggestion is to save the cursor which was the result of the query into a foxpro version 2.x table as in :

copy to tablname fox2x

since such tables don't allow null values character fields will become blank, numeric fields will be zeroed and data fields will be empty. Probably just the kind of table you are looking for.
-Dore