>>>Hi all,
>>> I finally figured out how to do a left outer join but in the fields with no match I have .NULL. showing in my report column. There must be a simple way to remove it but I haven't worked with nulls before.
>>>
>>>
>>>Many thanks in advance to all the helpfull people at this site.
>>
>>John, you can put
>>NOT ISNULL(myfield)
>>into Print When condition for the report field.
>
>Or you can use nvl function in your SQL.
That's correct.
Often in my SQLs I leave NULLs as is to be able to distinguish the real empty values in records from those which resulted in NULLs, when I am browsing the cursor. It makes debugging easier. So I prefer to use NULLDISPLAY and !ISNULL(myfield)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison