You can append a new collation to your select query to find case sensitive or insensitive. 

    SELECT *
    FROM TABLE 
    WHERE Name collate SQL_Latin1_General_CP1_CS_AS like '%hospitalist%'

    SELECT *
    FROM TABLE 
    WHERE Name collate SQL_Latin1_General_CP1_CI_AS like '%hospitalist%'