InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 04:19:41 GMT20http://www.sqlservercentral.com/Forums/Topic1380943-391-1.aspxCoverting to Nvarchar resolved the issue.Mon, 05 Nov 2012 09:11:36 GMTemile.milnehttp://www.sqlservercentral.com/Forums/Topic1380943-391-1.aspxThe surname column is varbinary(200) in the table.Mon, 05 Nov 2012 03:57:43 GMTemile.milnehttp://www.sqlservercentral.com/Forums/Topic1380943-391-1.aspxWhen I run the following it only returns one character for the surname field.Any Ideas why I'm not geting the full surname.USE EncrypteddbGOOPEN MASTER KEY DECRYPTION BY PASSWORD = 'Masterkeypassword' OPEN SYMMETRIC KEY EncryptionKeyDECRYPTION BY CERTIFICATE EncryptionCertificate;SELECT CONVERT(VARCHAR(500),DECRYPTBYKEY(surname)) AS surname, *FROM dbo.encrypted_tableGOMon, 05 Nov 2012 02:56:18 GMTemile.milne