Please help me, how to make SQL server table columns case sensitive

<i><b>Originally posted by : Dileep Kumar (dileep_k@rediffmail.com)</b></i><br />Hai friends, please help me ASAP i am facing a problem with sql server, i want to make tha columns case sensitive, for the login table, now it is accepting anything i mean caps or lower case letters.<br />

<i><b>Originally posted by : rocky</b></i><br />Well when u send ur variables of "username" & "password" to the next page..just change to lowecase and get them to compare with whatever u have into ur databse by converting with LCase(rs("username")) and try to store their username and password in lowercase as well while registering..its easy for login problems!!<br /><br />cheers!!<br /><br />rocky~~

<i><b>Originally posted by : Mike Hingley (mike.hingley@aquila-networks.co.uk)</b></i><br />I think that this actually makes the server case insensitive. The same technique could be used by comapring UCase with Upper values.<br /><br />Here's what I interpret the situation as being:<br /><br />If there are 3 records in a table:<br /><br />Recid | Description<br />---------------------------<br />1a |This is a record<br />1A |Another record here<br />ab |Yet another record<br /><br />If a user was to request the description for ia, then 2 records would be returned, as SQL interprets 1a and 1A as identical.<br /><br />If this is the case, then this can be resolved by setting a flag durting installation. Unfortionately this makes everything case sensitive. USE WITH CAUTION..<br /><br />There are various MS Technnet offereings, I suggest that you look there<br /><br />Mike Hingley - MCP<br /><br /><br />------------<br />rocky at 8/26/2001 10:34:46 AM<br /><br />Well when u send ur variables of "username" & "password" to the next page..just change to lowecase and get them to compare with whatever u have into ur databse by converting with LCase(rs("username")) and try to store their username and password in lowercase as well while registering..its easy for login problems!!<br /><br />cheers!!<br /><br />rocky~~