How to deal with case-sensitive joins

  • Thread starter Thread starter DOYLE60
  • Start date Start date
D

DOYLE60

I have a mainframe table that I'm linking that has a case-sensitive key. I do
not like the methods described in how to handle this on the microsoft knowledge
base.

What I wish to do is change the key in a query. Something like:

NewKey: IIf(Keyfield = uppcase and not a number, KeyField & "Up", KeyField &
"Low")

The keyfields are: 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, a, b, c, etc, A, B, C, etc.

So there are numbers as well. They can be left alone. And each key field is
only one character long. Oddly, a limit of 62 which is okay in this case.

So the question is, how do I do that first part of the IIf clause: "Keyfield =
uppercase and not a number"? Is there a function for it?

Matt
 
or use the function IsNumeric
-----Original Message-----
Try using the Asc() function. This converts the string
into an Ascii character code:
48-57 = 0-9
65-90 = A-Z
97-122 = a-z

IIf(Asc(Keyfield)>=65 AND Asc(Keyfield)<=90, _
KeyField & "Up", KeyField & "Low")

hope this helps!

case-
sensitive key. I do KeyField
& "Up", KeyField & c,
etc, A, B, C, etc.
.
Click to expand...
 
Back
Top