How to convert varchar or nvarchar to varbinary in SQL Server 2005?

Question

Niradhip Chakraborty · Answer

This cast statement should work DECLARE @X varbinary(20) Set @X = CAST('Testing' As varbinary(20)) Select @X As [varbinary] CAST(@X as varchar(20)) As [varchar]