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,