Access query- Filter all CAPS entries

[oliver1]

I have a LastName field with both upper and lower case entries. Some names are entered in all caps (ie DOE) while others are First letter capital letter (ie Doe) Does anyone know of a query that would filter out the all caps entries???
Thanks in advance for your help!

[pclement]

Well Access doesn't support case sensitive queries so you're limited to a few options.

If you're doing a comparison in your SQL statement you can use the StrComp function. However, if you need to check each LastName value then you will have to write a VBA function, which checks each character in order to determine whether the value is all caps, and call this function from your SQL query.