CONVERT BINARY TO VARCHAR AND VIEW CODE HEX | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

CONVERT BINARY TO VARCHAR AND VIEW CODE HEX

I need convert field binary in character.
But i like view this value of field the characters hex. example this value :
0x3DD8F4A6D9C1
I need :
3DD8F4A6D9C1
The convertion to varchar transform in characters asc
select cast(0x3DD8F4A6D9C1 as varchar)
result
=Øô¦ÙÁ
On the Books online show
SELECT CAST(CAST(0x41 AS nvarchar) AS varbinary) create table test
(
field binary(16),
field2 varchar(16)
) insert into #test values(0x3D84F5E628837841B897D46D5A6F31D4, ”) update #test
set field2 = field www.macul.eti.br www.macul.hpg.com.br www.primeiramao.com.br
(ad free)
There’s an undocumented xp that will do this. Use at your own risk. master.dbo.xp_varbintohexstr
master.dbo.fn_varbintohexstr http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4994 www.elsasoft.org
]]>