Encode and Decode Text

[nandanak]

I use ENCODE progress function to Encode some text and save it to database.
If I want to see the original text from Encoded text in DB, What should I do?

 

[Rob Fitzpatrick]

ENCODE is a hash function (though not a very good one). It is a one-way operation by design. There is no DECODE.

If you want reversible encryption, to protect sensitive data while it is in the database, then you should look at the ENCRYPT and DECRYPT functions. Be sure you have a good understanding of encryption and key management before you implement them.