How to convert a String to Hex and vice-versa?
As you know , in MySQL we have HEX & UNHEX, for example when I write like this :
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 ...
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