You're welcome.

>Hello Sergey,
>
>Thanks very much for the information.
>
>Regards
>Paul
>
>
>>Hi Paul,
>>
>>It's somewhat documented in the Readme.htm on VFP installation CD:
>>
>>"Left Outer Join returns zero records on nulls.
>>If a Left Outer Join uses Upper(), and the variable is null, zero records will be returned. This is a change from the incorrect behavior in Visual FoxPro 6.0, which returned a single record.
>>Because there were several instances where SQL SELECT statements could return incorrect result sets in previous versions of Visual FoxPro, several changes were made in Visual FoxPro 7.0. You should verify that your SQL SELECT statements return expected result sets".
>>
>>

--sb--