lcEncryptPassword = "XhTYtykkgy12345" * Encript field lickey (assuming) that it wasn't encrypted yet) SELECT keytbl REPLACE ALL lickey WITH Encrypt(lickey, lcEncryptPassword) ... * Now you found record you need and want decrypt lickey lcLicKey = Encrypt(keytbl.lickey, lcEncryptPassword)