xxxxxxxxxx
-- check collation using
SELECT SERVERPROPERTY('collation')
-- change CI to CS to make case sensitive
-- Make the column itself case sensitive example
SELECT *
FROM TABLE
WHERE Name collate SQL_Latin1_General_CP1_CS_AS like '%hospitalist%'
-- here CS means case sensitive