How to force Case Sensitivity in a pssword column

[bgreenhouse]

HI Everyone

I know you need to set up case sensitivity when you set up the server, but I can't figure out how to change it, and I'm wondering if I can just change it for one column. An article at MS (

http://msdn.microsoft.com/library/d...dnsql2k/html/intlfeaturesinsqlserver2000.asp)

sort of implies that you could change collation on one column.

I have a table with cardnumber and password. A form sends cardnumber and password to a stored procedure, which checks to see if there is one record with that cardnumber and password in the login table. If there is, it returns a login result code that redirects the user to the members section. Right now the PW isn't case sensitive. Do I have to reinstall the whole database to make that work? Or is there an easier way?

Ben

 

[tlbroadbent]

You can change the collation of a single column. Books Online explains how in the Alter Table topic. You can also refer to the article at the following link.

http://msdn.microsoft.com/library/en-us/architec/8_ar_da_819v.asp

The next link is to the T_SQL reference on the "Alter Table" topic.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_aa-az_3ied.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.