MS Access 2010 search case senstive values within two columns
Posted on 2013-02-07
My problem is that I have two columns, both with alphanumeric values. This two clumns have the same data but in different cases.
One Column may a field with Uppercase alphabets within the field say "12345DF2313tjm" this is compared to the other column's value "12345df2313tjm".
I have over 10,000 rows with similar case mismatch. How can I make access compare the two columns, then if there is a case mismatch, put a new value on a new column all in upper case. In this case the new coulmn would have "12345DF2313TJM"