Home Forums SQL Server 2008 SQL Server 2008 - General Decryptbykey RE: Decryptbykey
e4d4
SSCertifiable
Points: 5777
More actions
January 21, 2013 at 5:52 am
#1579218
robert.nesta123 (1/21/2013)...but when I filter on REG.....
robert.nesta123 (1/21/2013)
but when I filter on REG.
....
You can't filter on REG in this way, because it is encrypted, you can filter only on a decrypted value so:
CONVERT(nvarchar(200),DECRYPTBYKEY(REG)) like '%DY%'