>>In other words, seems like LIKE comparison doesn't work when there are some extra characters in the field even spaces. = ignores spaces.
>
>Ah, got you now. You are right, it has blank characters at the end of it. I will see how this is getting into the field and fix it. Thanks.

I found recently that we were saving varchar fields with spaces from VFP. You need to apply cursorsetprop("MapVarchar", .t., 0) before opening tables and also use a special format for text fields to prevent spaces beeing saved with the fields.