I'm developing an ASP.NET application using SQL Server Stored Procedures. I need to hash my login password and resolve it in my sp\_LoginCheck Stored Procedure.

Any suggestions?

I have already inserted data in the database.

For example:

```
UserName/Password

ABC/123456

DEF/987654

```

I want to encrypt or hash whatsoever the password then decrypt it in the stored procedure and query the table so that I can acquire the data.