Try something like this (the collation is key - you need to make sure the sure is case-sensitive:
select *
from mytable
where patindex('%[ABCDEFGHIJKLMNOPQRSTUVWXYZ]%',mytable COLLATE Latin1_General_CS_AI)>0
Now - this is going to cause scans, so will not be the fastest thing on the planet to run.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?