Bill: Thanks a lot for your help, that is what I was looking for, I sure have missed that function.
>>In an SLQ result with outer join condition to a cursor the columns that don't find a match do get a .NULL. value, is there a way to have VFP put a 0 (zero) or spaces depending on the field type?
>
>Hi Jorge,
>
>The NVL() function should help you with this.
>
>Bill
Jorge Flores
From the Amigo Country