>If I do a select Left Outer join, I end up with Nulls in the fields where no match exists in the Joined Table.
>Is there any VFP setting where I can default these to zero (if numeric) or spaces(if Character) rather then Null.
>I know I can post process the table and do an if Isnull() , but my prererence is to avoid having to do this if it can be done.
>Thanks in advance
>
>Gerard
You could do this in your select:
SELECT MainTable.SomeField,;
NVL(LeftJoinedTable.NumericField, 0000000.00) AS NumericField,;
NVL(LeftJoinedTable.CharField, SPACE(??)) AS CharField;
FROM ....
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.