How to convert a String to Hex and vice-versa?

Question

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

select hex("Ali");

the convert result is : 416C69

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

In MSSQL I can't convert this, could you please give me an example for both of them ???

Thanks a lot ...

possible duplicate of [Converting a String to HEX in SQL](http://stackoverflow.com/questions/219245/converting-a-string-to-hex-in-sql) — Jon, Dec 01 '11 at 09:38

score 10 · Accepted Answer · edited May 23 '17 at 12:00

10

I think this should work

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

for vice versa

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

This will convert to varbinary, then you can convert varbinary to varchar

edited May 23 '17 at 12:00

Community

answered Dec 01 '11 at 09:43

Zohaib

1 Answers1