resubmitting because the first upload did not seem to work...
Here is the problem I am trying to solve.
I need to extract some information from a table, say Tab2, using a matching key from another table, say Tab1.
Tab1 has two columns, Col1 and Col2.
Col1 is digits (1, 2, 3...)
Col2 has letters (AA, Aa, aA, aa, AB etc)
I need to use Col2 to join to Tab2 and extract some data from Tab2, based on some criteria (like values of Col2).
The problem is that SQL is not differentiating between upper case and lower case values in Col2. So, AA is treated the same as Aa.
If I wanted to retrieve information for AA from Tab2, it gives me the information for AA, Aa, aA and aa.
How do I solve this problem?
Thanks to all who try to help.