DECLARE
	@TestString VARCHAR(100)

SET @TestString = 'Sarat'

SELECT CASE WHEN BINARY_CHECKSUM(@TestString) = BINARY_CHECKSUM(LOWER(@TestString)) THEN 0 ELSE 1 END AS DoesContainUpperCase
GO

DECLARE @string VARCHAR(10)

SET @string = 'Sarat'

SELECT
    CASE 
        WHEN @string LIKE '%s%' COLLATE Latin1_General_CS_AI  THEN 'Lower Case s found'
        WHEN @string LIKE '%S%' COLLATE Latin1_General_CS_AI  THEN 'Upper Case S found'
        ELSE 'No S found'
    END 

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 

DECLARE @t TABLE (Names VARCHAR(20))

INSERT INTO @t
SELECT 'sarat' UNION ALL SELECT 'Sarat' UNION ALL SELECT 'SaRaT' UNION ALL SELECT 'SARAT'

SELECT Names, CASE WHEN Names2=LOWER(Names2) THEN 1 ELSE 0 END 
FROM @t CROSS APPLY (SELECT Names COLLATE Latin1_General_CS_AI) x (Names2)