create functions for encrypt and decrypt of password

Question

How can I write functions for password encryption and decryption using EncryptByPassphrase and DecryptByPassphrase and use these functions while storing and retrieving password from user table.

the EncryptByPassphrase takes two parameters, a @passphrase and the @cleartext. what is this @passphrase?