I need to find some records that have a specific casing. However, by default, SQL Server is retrieving all the records that match my SQL no matter if the field is containing lowercase or uppercase characters. How can I force my SQL to retrieve the records in respect to the casing I am searching for?

Basically, I can have something like this:

select * from member where City='Petit-Rocher'

But, in the result, I also get Petit-rocher.