Case Sensitive Search in sql query

Case Sensitive Search in sql query

Case Sensitive Query Search – SQL Server

I have got a request to write a select query to get data by matching a column with case sensitive and I should not suppose to use any conversion function.

Then I came to know that there is a way to accomplish this using “COLLATE”

There are mainly two collations in SQL Server:

COLLATE Latin1_General_CS_AS – Case Sensitive

SQL_Latin1_General_CP1_CI_AS – Not Case Sensitive – Default Collation

I’ll give you an example

 

 

Posted in SQL Development | Tagged , , , , , , , , , , | Leave a comment

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz