Actually, this is simpler I think:

DECLARE @string VARCHAR(10)

SET @string = 'Sarat'

SELECT

CASE

WHEN @string = lower(@string) COLLATE Latin1_General_CS_AI

THEN 'No upper case found' ELSE 'Upper Case found'

END

Regards

Piotr