Here i encrypt the column value and inserting in a table,while im inserting encrypted value is stored as "spacevalues" in table....how can i solve this....this code i tried with dynamically....

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[ETL_Encrypt] (@inputcolumn VARCHAR(200),  @outputcolumn VARCHAR(max), @transtable VARCHAR(max))
AS
DECLARE @SQL VARCHAR(MAX)
BEGIN

SET @SQL= 'OPEN SYMMETRIC KEY TestTableKey DECRYPTION BY CERTIFICATE EncryptTestCert '
--OPEN SYMMETRIC KEY TestTableKey DECRYPTION BY CERTIFICATE EncryptTestCert
PRINT @SQL
EXEC(@SQL)
SET @SQL= 'UPDATE '+ @transtable +' SET '+ @outputcolumn +'= ENCRYPTBYKEY(KEY_GUID(''TestTableKey''),convert(varbinary,'+ @inputcolumn +'))'
--UPDATE TestTable SET EncryptSecondCol = ENCRYPTBYKEY(KEY_GUID('TestTableKey'),SecondCol)
PRINT @SQL
EXEC(@SQL)
SET @SQL= 'CLOSE SYMMETRIC KEY TestTableKey '
--CLOSE SYMMETRIC KEY TestTableKey
PRINT @SQL
EXEC(@SQL)
END