How to convert String to Hex and vice versa?

Question

As you know, in MySQL we have HEX and UNHEX, for example, when I write like this:

select hex("Ali");

conversion result: 416C69

and unhex looks like this: select unhex("416C69");

In MSSQL I cannot convert this, could you give me an example for both of them ???

Thanks a lot...

+4

Freeman Dec 01 '11 at 9:36

1 answer

Zohaib · Accepted Answer · 2011-12-01T09:43:17+0000

I think this should work

 SELECT hex(CAST("Ali" AS VARBINARY)) AS Expr1

for the contrary

 select CONVERT(varbinary(max), "416C69");

This is a conversion to varbinary, then you can convert varbinary to varchar