Answered by:
Hex to String

Question
-
How can I convert the hex code '0x16004D616E75623232' to string?
An online utility provides me its equivalent: http://www.string-functions.com/hex-string.aspx
But how can I do this by TSQL, CLR would be a second thought.
~Manu
http://sqlwithmanoj.wordpress.comWednesday, December 22, 2010 3:12 AM
Answers
-
If you are using SS 2008 or earlier, then check function CONVERT in BOL.
SELECT CONVERT(varbinary(64), '0x16004D616E75623232', 1), CONVERT(varchar(64), 0x16004D616E75623232, 1), CONVERT(varchar(64), 0x16004D616E75623232, 2); GO
For lower versions you can use some tricks from Umachandar Jayachandran.
AMB
- Marked as answer by Manoj Pandey (manub22)Microsoft employee Wednesday, December 22, 2010 4:14 AM
Wednesday, December 22, 2010 3:39 AM -
did you try master.sys.fn_varbintohexstr?
Craig- Marked as answer by Kalman Toth Thursday, April 17, 2014 1:17 PM
Wednesday, December 22, 2010 4:08 AM
All replies
-
If you are using SS 2008 or earlier, then check function CONVERT in BOL.
SELECT CONVERT(varbinary(64), '0x16004D616E75623232', 1), CONVERT(varchar(64), 0x16004D616E75623232, 1), CONVERT(varchar(64), 0x16004D616E75623232, 2); GO
For lower versions you can use some tricks from Umachandar Jayachandran.
AMB
- Marked as answer by Manoj Pandey (manub22)Microsoft employee Wednesday, December 22, 2010 4:14 AM
Wednesday, December 22, 2010 3:39 AM -
did you try master.sys.fn_varbintohexstr?
Craig- Marked as answer by Kalman Toth Thursday, April 17, 2014 1:17 PM
Wednesday, December 22, 2010 4:08 AM -
Thanks Hunchback,
Didn't thought it was so simple, actually my hex string had '1600' prefixed after 0x, on removing it I'm getting the expected o/p, which is:
SELECT CONVERT(varchar(64), 0x4D616E75623232, 0)
~Manu
http://sqlwithmanoj.wordpress.comWednesday, December 22, 2010 4:14 AM -
Thanks Craig,
But this is just opposite to what I was looking for.
~Manu
http://sqlwithmanoj.wordpress.comWednesday, December 22, 2010 4:16 AM -
This util also does the same https://codebeautify.org/hex-string-converter
- Edited by Jimoza Wednesday, June 14, 2017 11:54 PM
Tuesday, May 23, 2017 7:08 PM