>VFP6 - tables in DBC
>
>

select * from A inner join B on like(b.field, a.field)

joins up fine if b.field is of the form "ABC???", but does NOT join if b.field is of form "ABC*". The "*" like comparison works everywhere else, why not here? bug?
>
>TIA,

When joining, since it's comparing the whole field, it's actually in the form of "ABC* " - so it's trying to match "ABC" + however_many_characters + space(2) to the right side.

Try like(alltrim(b.field)), alltrim(a.field))