How to fetch lowercase or uppercase or mixed case, case sensitive string in SQL Server. Case sensitive search using select query. There are two simple ways .