• thanks it worked, i used....

    SELECTCAST( DecryptByCert( Cert_ID('DBCert'), Status ) AS VARCHAR(50) )

    FROMdbo.Status