query like to search for upper case characters

M

monsey11

Hi All,

I'm looking to create a query to look for 4 uppercase letters in a row
like "*[A-Z][A-Z][A-Z][A-Z]*" ain't working.

I'm using office 2007 beta.

I appreciate your time.

Thank You
 
R

Rick Brandt

Hi All,

I'm looking to create a query to look for 4 uppercase letters in a row
like "*[A-Z][A-Z][A-Z][A-Z]*" ain't working.

I'm using office 2007 beta.
Click to expand...

Access/Jet is not case sensitive and it is not easy to do case sensitive stuff.
The InStr() function can be used in some cases because it can be asked to
compare using the binary value rather than the text value. Not sure how that
could be adapted to your problem though. A custom VBA function could certainly
do the job, but might not be very efficient.
 
Top