I have a login table with following fields and data
Password varchar (8)
The Data is table is
Now if I am running the query :
select * from login where loginid='Bill' and Password=ENCRYPT('GATES'), the query works.
It should not work as the data in password field is not encrypted and both should not match.
Can anybody will provide the answer?