Find Column with Lower Case Text

SELECT *
FROM YourTable
where YourCol LIKE '%[a-z]%' COLLATE Latin1_General_BIN

Source: Unknown
Viewed 14361 times