The standard method of handling them is to store the encrypted value in the database. When a user logs in, the password they submit is encrypted using the same algorithm and compared to the stored encrypted value.
Passwords can thus use one-way encryption algorithms, which are more secure than two-way algorithms.
If you would like a function for one-way password encryption, I can post one for you.
If it's not practically useful, then it's practically useless.
SQL 2005 comes with two functions "EncryptByKey" and "DecryptByKey". If you have BOL installed on your machine, look over this article:
I've already got an idea on how to encrypt data by using the EncryptByKey but when i try to decrpyt it using the DecryptByKey it doesn't return the original text. I've already posted that problem HERE. COuld anyone help me on this..thanks!!!