lynmke
asked on
MS Access 2010 search case senstive values within two columns
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"
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"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER