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?
"ABC* "
- so it's trying to match "ABC" + however_many_characters + space(2)
to the right side.like(alltrim(b.field)), alltrim(a.field))