Case sensitive search via Unicode

[Cornelius19]

Hi,

Do you know how to make a case sensitive search on SQL Server? I was thinking about converting the words to Unicode via a VB Script. Does any of you have such a script?

Thanks,

Cornelius

 

[gmmastros]

Take a look at this: thread183-1305916

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ca8msm]

thread183-1361786 might be of some use to you.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[Cornelius19]

Thank you, both. The "Where Data Collate SQL_Latin1_General_CP1_CS_AS" works fine for me.

Cornelius