Find records with mixed case

[Hal Pratt]

I have database of some records in all caps and others in Proper or upper
and lower case text. Is there an expression I can use in a query to identify
either group?

 

[John Spencer (MVP)]

You might use the INSTR function along with UCASE or LCase to detect them. Use
Binary Compare (0) to detect differences in Case.

SELECT YourListOfFields
FROM YourTable
WHERE Instr(1,UCase(Somefield),SomeField,0)= 1

That should get all records where somefield is all upper case

Change the =1 to =0 to get all records where the field is mixed case or all
lower case