Microsoft SQL Server Like keyword

Question

Any inputs on making Like keyword in Microsoft SQL server act as Case-sensitive.

For example : Name Like 'David' gets all the names David or david or daVid etc. My goal is to get only David.I am interested in knowing different ways from the experts.

Answer 1

You need to use collation.

SELECT * FROM myTable  
WHERE LastName COLLATE Latin1_General_CS_AS = 'smyTH'