• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

data match

 
Nimish Patel
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
have a good day...................

now i have a one table name "usertable" having a column like this
(1)user (2)password.

i want to perfect match of password.
suppose table have a "AbcD" password.

in simple query ,
"select * from usertable where password="abcd";"
this query returns data. but this query should not be return data.
because in database password="AbcD".

so what query i write to do exact match ?

thanks,
Nimish Patel
 
moh sak
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I try to do something like that and it works my sql command was like this :

String SQLCommand = "SELECT * FROM usertbl WHERE password = 'abcd' " ;

reTry your quesrt and i think it should work
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic