>>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))

Trey,

yeah - I finally figured this out (posting a question does wonders huh?) - you only need th ALLT on the b.field though ..

Thanks!