Type this into the Field row in query design:
StrComp([MyField], UCase([MyField]), 0)
Substitute your field name for MyField.
In the Criteria row under this, enter a zero.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
Eugene said:
In our dB someone enter descriptions in capital letters. I need to
Identify
those entry. How can I do that?
