Find records with mixed case

  • Thread starter Thread starter Hal Pratt
  • Start date Start date
H

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?
 
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
 
Back
Top