Randall,

The index has to exactly match the join / filter criteria. With your current syntax, the indexes would need to be ALLTRIM(companyid).

>I'm little confused. Do you mean the actual index in both tables are ALLTRIM(companyid) or the index is on companyid?