Check if lowercase in SQL statement

Question

I'm using MS-access, and need to write a select query to find all rows where the cell value contains lowercase characters.

i.e. aa, aA or Aa but not AA

Can this be done?

Answer 1

http://support.microsoft.com/kb/304258

Lower:StrComp(LCase([Field1]), [Field1],0)
Criteria: <>0

or as filter

WHERE StrComp(LCase([Field1]), [Field1],0)