SQL Server – Insert String Value into a Binary Column (64)

I'm trying to use a stored procedure to insert data into a table. The DDL of my table is like this:

CREATE THE TABLE [dbo].[data1](
    [ID] [int]    IDENTITY (1,1) NOT NULL,
    [fname] [varchar](100) NOT NULL,
    [lname] [varchar](100) NOT NULL,
    [phone] [varchar](10) NULL,
    [company] [varchar](100) NOT NULL,
    [email] [varchar](100) NOT NULL,
    [pass] [binary](64) NOT NULL,
    [registrationdate] [datetime]    NO,
CLUSTERED PRIMARY KEY
(
    [ID] ASC
) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) SURE [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[data1] SURE
GO
INSERT [dbo].[data1] ([ID], [fname], [lname], [phone], [company], [email], [pass], [registrationdate]) VALUES (1, N & # 39; Bob & # 39 ;, Tomato # 5555555555; N & # 39; Test Company & # 39 ;, N & # 39; test1234 @ test.com & # 39 ;, 0x477265656E00000000000000000000000000000000000000000000000000, NULL)
GO
SET IDENTITY_INSERT [dbo].[data1] OF
GO

And here is the stored procedure that I try to run:

Declare @FName varchar (100) = 'aa & # 39;
Declare @Lname varchar (100) = & bb & # 39; bb & # 39;
Declare @Phone varchar (100) = "c & # 39;
Declare @Company varchar (100) = "dd & # 39;
Declares @Email varchar (100) = ee & # 39;
Declare @Pass binary (64) = redsocks & # 39;


INSERT INTO dbo.appinfo (fname, lname, phone, business, email, pass)
VALUES (@FName, @Lname, @Phone, @Company, @Email, CONVERT (VARBINARY (64), @Pass, 0))

but I get this error:

Msg 257, Level 16, State 3, Line 20
Implicit conversion of the varchar data type to binary is not allowed. Use the CONVERT function to execute this query.

Does this statement not convert the value correctly?

CONVERT (VARBINARY (64), @Pass, 0))