HA! HA!

SET ANSI...

If the ALLTRIM() is still in place on the VFP comparsion, if SET ANSI=ON
returns the false positive. IF SET ANSI is off, then the result is correct.

IF the ALLTRIM() is not in place, then SET ANSI doesn't appear to affect the result either way, it always comes out with the false positive.

-- L



>>Borislav...
>>
>>>What is the result of that query:
>>

>>
>>SELECT jet.last_name,jet.first_name,jet.ssn;
>>FROM jet;
>>LEFT JOIN Person ON jet.ssn == Person.Ssn;
>>WHERE Person.ssn IS NULL
>>

>>
>>The result is the same (i.e....it is WRONG).
>>

>>>WAIT WINDOWS TRANSFORM(LEN(jet.ssn))+[   -   ]+TRANSFORM(LEN(Person.ssn))
>>

>>C - C
>>

>>>WAIT WINDOWS TYPE([jet.ssn])+[   -   ]+TYPE([Person.ssn])
>>

>>11 - 11
>>
>>Actually, I was finding this problem before when JOINING, and that is why I was trying to figure out using the sub-SELECT.
>
>HA!
>SET ANSI ?
>SET EXACT ?