Enforce case sensitive while searching

We can enforce case sensitive search on case-insensitive databases using the below command.


use kalyandb
go
select * from customers where name='KALYAN'
collate SQL_Latin1_General_CP1_CS_AS

select * from fn_helpcollations() -- displays list of collation names supported by sql server.