I have upgraded a VFP application to use a SQL Server backend using ODBC. When I do a SELECT on the SQL Server using an Outer Join, the records that exist in Table A, but not in Table B show .NULL. values for the fields returned from table B.
My existing VFP code does not handle .NULL. values therefore the simplest way to solve this problem is to find a way to ensure .NULL. values are not returned or to write a very efficient routine to fix the .NULL. values.

Any ideas?

P.S. I have tried setting SET NULL OFF but this does not help.