Case sensitive SQL Select query


I want to treat my password field as case sensitive i.e
BIN,bIn,bin..all are different password.How can i write select query for this as simple query like "Select * from ADMIN_TABLE where Passowrd= 'admin' " wont work.I am using sql server 7

pleas suggest me..

Thanks and regards,


  • Hi Nikhil,

    The case sentivity of SQL Server depends on collation. You can set a case-senitive collation for your password column to acheive this. You can try SQL_Latin1_General_CP1_CS_AS.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


In this Discussion