Advertisement

12.20.2007 at 08:16PM PST, ID: 23037570
[x]
Attachment Details

Compare case sensitive string

Asked by sepknow in SQL Server 2005

Tags: Microsoft, SQL Server, 2005, 9.0.2047 SP1

I notice my SQL Server 2005 uses
SQL_Latin1_General_CP1_CI_AS
collation which ignore case when comparing string.

How can I overcome this limitation?Start Free Trial
[+][-]12.20.2007 at 08:26PM PST, ID: 20511724

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: SQL Server 2005
Tags: Microsoft, SQL Server, 2005, 9.0.2047 SP1
Sign Up Now!
Solution Provided By: appari
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628