Validation for password field

• Chandru -734144

  Ten Centuries

  Points: 1040

  More actions

  October 23, 2008 at 1:20 am

  #200004

  Hi all,

  I have a problem with the folllowing scenario that i have inserted the different password into my table but when i try to retrive the username and details for a particular user by pasword it's retriveing all three records instead of retriveing one record,Can any one help me on this

  My Query

  select * from login where pwd='Test123'

  but when i try to retrive record with username i'm getting the correct o/p

  select * from login where name='Martin' and pwd='Test123';

  Following is the script,

  --

  create table login(name varchar(20),pwd varchar(20));

  insert into login values('Martin','Test123');

  insert into login values('Ricky','test123');

  insert into login values('Watson','tesT123');

• krayknot

  SSCertifiable

  Points: 7998

  More actions

  October 23, 2008 at 1:44 am

  #888491

  Chandru (10/23/2008)

  ---

  Hi all,

  I have a problem with the folllowing scenario that i have inserted the different password into my table but when i try to retrive the username and details for a particular user by pasword it's retriveing all three records instead of retriveing one record,Can any one help me on this

  My Query

  select * from login where pwd='Test123'

  but when i try to retrive record with username i'm getting the correct o/p

  select * from login where name='Martin' and pwd='Test123';

  Following is the script,

  --

  create table login(name varchar(20),pwd varchar(20));

  insert into login values('Martin','Test123');

  insert into login values('Ricky','test123');

  insert into login values('Watson','tesT123');

  For case sensitive search, use varbinary for ex:

  select * from login where Convert(varbinary(8),pwd)= convert(varbinary(8),'Test123')

  kshitij kumar
  kshitij@krayknot.com
  www.krayknot.com

• ck9663

  Right there with Babe

  Points: 763

  More actions

  October 23, 2008 at 2:00 am

  #888495

  That would mean your table have three different records with the same password. Depending on your requirement, you can setup USERNAME & PASSWORD as unique index keys.

  -- CK

• Chandru -734144

  Ten Centuries

  Points: 1040

  More actions

  October 23, 2008 at 2:03 am

  #888496

  Thanks Mr.Krayknot it worked well..

  Cheers.

• krayknot

  SSCertifiable

  Points: 7998

  More actions

  October 23, 2008 at 2:32 am

  #888502

  Chandru (10/23/2008)

  ---

  Thanks Mr.Krayknot it worked well..

  Cheers.

  You are most welcome

  kshitij kumar
  kshitij@krayknot.com
  www.krayknot.com

• arjun.tewari

  Ten Centuries

  Points: 1013

  More actions

  October 23, 2008 at 4:23 am

  #888525

  Chandru (10/23/2008)

  ---

  create table login(name varchar(20),pwd varchar(20));

  insert into login values('Martin','Test123');

  insert into login values('Ricky','test123');

  insert into login values('Watson','tesT123');

  If such situation is very common, I would suggest you to look in the collation settings.