[sql] Detecting / Filtering All Caps Text

Needed to detect if a field contained all caps / uppercase text. Once again, Yodakawa comes to the rescue.

-- Retrieve rows where FooText is not all caps 
--(using it in where clause)
select top 100 FooText, * from FooTable 
where FooText like '%[abcdefghijklmnopqrstuvwxyz]%' 
   COLLATE SQL_Latin1_General_CP1_CS_AS

-- Syntax for using it in the select
select top 100 
 isnull((case when FooText like '%[abcdefghijklmnopqrstuvwxyz]%' 
              COLLATE SQL_Latin1_General_CP1_CS_AS 
         then description2 else '' end), '')
from FooTable