>>>I said using == operator:
>>>
>>>

>>>local id
>>>Id = "BONAP"
>>>Id = "BONAP                                      "
>>>
>>>Select * from _samples + 'data\Customer' ;
>>>where Cust_id == m.Id
>>>
>>>Id = "BON" && no spaces but no match as well
>>>
>>>

>>>
>>>Either field cust_id or m.id might have as many as trailing spaces you wish. During select trailing spaces would be automatically removed for comparison (also check SET ANSI).
>>
>>Yes, and that's because the string you search for is longer that the field value, and every character match up to the length of the field. Try ID = "B ".
>>
>>BTW I have Set Ansi Off, which makes a big difference.
>>
>>NB! Let's leave it, I'm going to bed.
>
>OK :) But you seem to be unaware that == behaves like an implicit SET ANSI ON.

Wrong, I know that. Actually I believe we are both misunderstanding each other.