Changing passphrase for EncryptByPassPhrase I am using EncryptByPassPhrase to encrypting some columns.

If I want to change the passphrase in the future, how can I change it?
You'll need to decrypt the data using the existing password then encrypt the value using the new password.