In my tests in VFP 6 and 7 I got the same result with and w/o ALLTRIM(). It looks like VFP was just ignoring ALLTRIM() in join condition.
>Hi Sergey,
>
>you wrote something about the use of ALLTRIM(). I checked it twice in VFP 6 and 7 - it works fine. There is a difference with the == Operater in SELECT SQL, it does always ALLTRIM(). But I use =.
>
>Or is there a deeper problem?
>
>Thank You
>
>Agnes
--sb--