Case Insensitivity

[meyerryang]

I have Oracle tables in the background, which are usually case sensitive. I
want to query out of them and get a list regardless of case sensitivity, but
am having difficulty. So if I wanted to find Bob, I would get.

Bob Smith

But I wouldn't get all of them:
Bob Smith
bob smith
boB SmitH

I have: is like "*Bob*" in the criteria. What can I do to get it to work???

 

[KARL DEWEY]

Try using a calculated field like this --
MyNameField: Upper([NameField])
then criteria --
Like "*BOB*"

 

[meyerryang]

Works great! I do think you meant UCase([NameField]). Access vs Excel.
Thanks again.

Try using a calculated field like this --
MyNameField: Upper([NameField])
then criteria --
Like "*BOB*"
--
KARL DEWEY
Build a little - Test a little

I have Oracle tables in the background, which are usually case sensitive. I
want to query out of them and get a list regardless of case sensitivity, but
am having difficulty. So if I wanted to find Bob, I would get.

Bob Smith

But I wouldn't get all of them:
Bob Smith
bob smith
boB SmitH

I have: is like "*Bob*" in the criteria. What can I do to get it to work???

 

[KARL DEWEY]

UR rite, did not test - not use long time.
--
KARL DEWEY
Build a little - Test a little

Works great! I do think you meant UCase([NameField]). Access vs Excel.
Thanks again.

Try using a calculated field like this --
MyNameField: Upper([NameField])
then criteria --
Like "*BOB*"
--
KARL DEWEY
Build a little - Test a little

I have Oracle tables in the background, which are usually case sensitive. I
want to query out of them and get a list regardless of case sensitivity, but
am having difficulty. So if I wanted to find Bob, I would get.

Bob Smith

But I wouldn't get all of them:
Bob Smith
bob smith
boB SmitH

I have: is like "*Bob*" in the criteria. What can I do to get it to work???