Help with like operator

[Al]

I have a field that I am trying to filter any record that Has an upper case
letter at the end of the record [A-Z]. I used like "*[A-Z]" however, I am
getting upper and lower case as well. I am only interested in Upper case. any
idea?
thanks
Al

 

[KARL DEWEY]

Access treats upper and lower case the same.

Add a new field to the grid in design view like this --
A-Z_Check: Asc(Right([YourFieldName],1))
Use criteria Between 65 And 90

 

[Al]

Thank you, it worked

Access treats upper and lower case the same.

Add a new field to the grid in design view like this --
A-Z_Check: Asc(Right([YourFieldName],1))
Use criteria Between 65 And 90

--
KARL DEWEY
Build a little - Test a little

I have a field that I am trying to filter any record that Has an upper case
letter at the end of the record [A-Z]. I used like "*[A-Z]" however, I am
getting upper and lower case as well. I am only interested in Upper case. any
idea?
thanks
Al