Howdy, Stranger!

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

Categories

Case sensitive SQL Select query

Hi,

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,
NIKHIL.

Comments

  • ShanooShanoo Member Posts: 32
    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.