Upper and Lower case characters a challenge! (1 Viewer)

[jacksodm]

Hi,

I'm not a programmer and have searched for so many hours trying to figure out if there's any way I can get MS Access queries to not see matches when alphanumeric character strings vary by only one uppercase character (or lowercase character).

I have 15 characters that generally the last 4 change, mostly the last 2, but are two separate records separated by one character, eg, XXXXXXXXXXXXXXB and XXXXXXXXXXXXXXXb. I'm trying to link over a million records with these type of id's and have permanent keyboard imprints on my forehead.

I couldn't possibly be the only one out here with this issue??? Anyone encounter this and figure it out? I would really, really, realllllly, REALLLY appreciate the help.

Trying to find the light upper and lower case way,
-dj

 

[John Big Booty]

Welcome to the forum.

Perhaps the article here will give you some pointers.

 

[Beetle]

The following link outlines a few different methods that could be used. StrComp would be the simplest to implement but with > 1 million records performance may be too slow, so you may have to look at one of the other methods;

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q244693