MSSQL Equivalent to MySQL ENCRYPT/DECRYPT

Hi all. I'm having to convert a database over from MySQL to MSSQL 2000.

The problem I'm encountering is that there's a password field that is using ENCODE and DECODE to set and retreive the password, and I'm unable to find an equivalent to this in MSSQL.

So, my question is:
Is there an equivalent to ENCODE/DECODE in MSSQL or is there a standard function a DBA would use that duplicates this functionality. If there's nothing of the sort, then what would you recommend to be the best way to go about this without having to ask all your users to reset their passwords?

Thanks.

re: MSSQL Equivalent to MySQL ENCRYPT/DECRYPT

Try these.



--- CK