Check if lowercase in SQL statement

I'm using MS-access, and need to write a select qu开发者_如何转开发ery to find all rows where the cell value contains lowercase characters.

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

Can this be done?

---

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

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

or as filter

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