>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.
You can use Collate. I covered it in my SQL column in UT magazine a while ago.
--sb--