Case-sensitive 
Author Message
 Case-sensitive
Hi,

My SQL Server 2000 database has been installed in case-
insensitive (by default). Now, is there any way to switch
or make the queries for the string as Case-sensitive? I
want that the following query won't return the lower case
result:
SELECT * FROM Table1
WHERE Code = 'MA-1234'

Best regards,
Boi Hue



Fri, 06 Jan 2006 19:24:24 GMT
 Case-sensitive

Check out COLLATE in the BOL.

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql

Hi,

My SQL Server 2000 database has been installed in case-
insensitive (by default). Now, is there any way to switch
or make the queries for the string as Case-sensitive? I
want that the following query won't return the lower case
result:
SELECT * FROM Table1
WHERE Code = 'MA-1234'

Best regards,
Boi Hue



Fri, 06 Jan 2006 19:28:50 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Case Sensitive Join on non case-sensitive sql server

2. Case Sensitive and not so Case Sensitive

3. Case sensitive to not sensitive reconfigure?

4. Question on Scope of Case-Sensitivity on a Case-Sensitive SQL Server 7.0/2000

5. SQL Server case sensitive or case insensitive.

6. Case sensitive restored into a Case insensitive DB

7. collation problem -- switch from case insensitive to case sensitive

8. Case-sensitive to Case-insensitive

9. Changing Case Sensitive Server to Case ensensitive

10. How to use both case sensitive and case insensitive search

11. Case-sensitive Join on case-insensitive database

12. case sensitive/ case insensitive -- ?


 
Powered by phpBB® Forum Software