>>See http://www.levelextreme.com/ViewPageArticle.aspx?Session=2B6E674575657847374E633D205243356D6B704B4E464E554E726474574E524D4273413D3D
>>
>>

>>select * from member 
>>  where City = 'Petit-Rocher' 
>>   AND  City COLLATE SQL_Latin1_General_CP1_CS_AS = 'Petit-Rocher'
>>

>
>Thanks, this works.

I provided you with the same code too. Was working on something else before, didn't see your message.