Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Case sensitive searching

Author  Topic 

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2010-08-02 : 18:25:51
Hi
I have come across a database app that has some records with a value of 'TME(+sn' and some that have 'TME(+sN' (note the capital letter at the end is the only difference)
This app treats them differently.
I have moved the data to a new app and need to group all the records that have 'TME(+sn' together and all of the 'TME(+sN' records together.
How can i do a case sensitive search?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-02 : 18:30:33
Use the COLLATE clause. Here's an example: http://www.novicksoftware.com/TipsAndTricks/tip-sql-server-distinct-case-sensitive.htm

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2010-08-03 : 01:16:51
Thanks again Tara.

Much respect to you and your colleagues who are always there to help out us lesser mortals
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-03 : 12:43:00
You're welcome.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -