#title Binary(hex, 16진수) 자체를 문자열로 나타내기
[[TableOfContents]]

==== 2000, 2005 버전 ====
{{{
create table #bin(b binary(1))
insert #bin values(0xff)
insert #bin values(0x0f)

select
	master.dbo.fn_varbintohexstr(b) binarytostr
from #bin
}}}

==== 2008 버전 ====
{{{
declare @chr varchar(4) = 'yasi';
declare @bin varbinary(4) = convert(varbinary(20), @chr);
select
	@bin bin
,	CONVERT(varchar(4), @bin, 0) style0
,	CONVERT(varchar(4), @bin, 1) style1
,	CONVERT(varchar(4), @bin, 2) sytel2
/*
bin        style0 style1 sytel2
---------- ------ ------ ------
0x79617369 yasi   0x79   7961

참고: sys.fn_varbintohexstr
*/
}}}

==== 적용 범위 ====
 * Microsoft SQL Server 2000
 * Microsoft SQL Server 2005
 * Microsoft SQL Server 2008