some great code suggestions
from a similar thread where someone needed to detect if lower case/upper case character exists:
http://www.sqlservercentral.com/Forums/Topic800271-338-1.aspx
this would check if the string is all UPPER:
DECLARE @string VARCHAR(10)
SET @string = 'Sarat'
SELECT
CASE
WHEN @string = upper (@string) COLLATE Latin1_General_CS_AI
THEN 'All upper case found' ELSE 'Mixed or lower Case found'
END
Lowell