I have a table with a column of binary literals converted to strings that I need to relate to a table containing the same value as binary(16) 

Root table string Value '2F774578C33011E880D80050569C29CA' 

table value I need to join to 0x2F774578C33011E880D80050569C29CA 

is there a way to convert either the root table to Binary by simply adding the 0x to the string then declaring the string a literal value for the binary? or convert the binary to the string contained in the root. 

I tried the following with no luck: 

```
DECLARE @jobIDBinary Binary(16) 
DECLARE @jobString Nvarchar(50) 

SET @jobIDBinary = '0x'+
(SELECT TOP (1) JobId

FROM  [Record]) 

```

error: Implicit conversion from data type nvarchar to binary is not allowed. Use the CONVERT function to run this query.

I also tried converting the other way: 

```
 DECLARE @convo varchar(max) 
 SET @convo = (SELECT TOP (1)
 [BinaryJobID]
 FROM [GAPClaims].[dbo].[Record2]

 WHERE binaryjobId IS NOT NULL ) 

```

Results = ,]óJ¾¶‡Á§\ê€

Thanks ahead of time.