• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 430
  • Last Modified:

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"
0
lynmke
Asked:
lynmke
  • 2
3 Solutions
 
mbizupCommented:
An easy way to do this - but not necessarily the most efficient is to simply uppercase your column:


UPDATE YourTable
SET YourField = UCase(YourField)

Open in new window

0
 
mbizupCommented:
Or if you are using a separate field:


UPDATE YourTable
SET YourNewField = UCase(YourOldField)

Open in new window


From your description, you don't really need a comparison, and uppercasing either field will give you your expected results.
0
 
Rey Obrero (Capricorn1)Commented:
You can use the Asc() function or the StrComp() function to have Microsoft Access differentiate between case-sensitive text strings.
see this link

How to Return Case-Sensitive Matches in Queries

http://support.microsoft.com/kb/209674

you can run a query like this

update tableName
set [newcolumn]=ucase([Column1])
where strcomp([column1],[column2],0) <>0
0
 
lynmkeAuthor Commented:
Thanks, all solutions accepted.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now