Randall,

It's best to avoid index expressions on character fields which return a variable length for the field value. ALLTRIM() will return a variable length.

Brien is suggesting that you take the ALLTRIM expression off and make sure that the fields on both sides of the ON expression are indexed for best performance.

Jay

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