I've tryed the code provided in that site
I use it to save encrypted passwords into my db

But I've a problem when I try to select records

i.e. My webuser try to login and input username/password
In ASP I create a select like this

SQL = "Select * from users where password='" & Encrypt(usr_pwd) & "'"

If the encrypted text has particular char (I think reverse ') the
contatenation produces a bad SQL variable, If i try to response.write
SQL it is empty

Is it better to save an hexadecimal encrypted string in DB to avoid
these characters? Is there any algorithm that does it? I need decrypt
function also.


Thanks

*** Sent via Developersdex http://www.developersdex.com ***