Encrypted data getting changed

Question

Hi All,

am writting an Update query Which will set data to password colomn, this data is encrypted and am updating data accross database (from 1db to other db).

UPDATE dbname.dbo.tblnm SET PwdCol=(Select PwdCol FROM tblnm WHERE pkCol=11111) WHERE pkCol=11111