encrypt password

Hi,

I would like to encrypt and decrypt password in my own tables

select stuff

from mytable

where password = decrypt('ackdo$$y')

How can I do this? Is there any decrypt or crypt function?

thanks,

Are you using SQL Server 2005 ? Then you will have the option to use the Encryptby functions, if you don′t want to use them you can implement your own using CLR functions. If you are using SQL 2k you either will have to write a XP for more sophisticated encryption, for low encryption you could use a stored procedure or function, if you don′t want to do this on the server, you will have to do it on the client.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi.

I am using sql 2005. Therefore how can I use this encrypt or decrypt function?

cheers,