>I said using == operator:
>
>
>local id
>Id = "BONAP"
>Id = "BONAP "
>
>Select * from _samples + 'data\Customer' ;
>where Cust_id == m.Id
>
>Id = "BON"
>
>
>
>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.