Get exact string with SQL

John

10y887Code

This query will give you exact records with case sensitive.

How to get the exact string from database with case sensitivity

select * from memdetails where loginid='abc'
will give you record of loginid with abc only and ABC

select * from memdetails where loginid='abc' COLLATE SQL_Latin1_General_CP1_CS_AS
will give you record of loginid with abc only and not ABC

select * from memdetails where loginid='ABC' COLLATE SQL_Latin1_General_CP1_CS_AS
will give you record of loginid with ABC only and not abc