How to make a Merged Query non case sensitive?

Hello   I joined two tables with Merged Query using Left Outer join.   It appears it only matches case-sensitive data and it omits all the non case-sensitive matches.   How can I fix this?   ...