Does it work correctly with the INNER JOIN for matching records only?
>No.
>
>>>Wouldn't LEFT JOIN ON alltrim(upper(table1.aid))==alltrim(upper(table2.bid)) work regardless?
>>>
>>Yes, it would. Never used such construction in JOIN myself, but it would work regardless, you're right. Do you have NULL in any of ID fields?
If it's not broken, fix it until it is.
My Blog