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