Dear All,
Please kind help how to convert a binary object to a string with original format. eg.
create table #t1(a varbinary);
insert #t1 values(0x6861);
create table #t2(str varchar(100));
-----------------------------------------------------
Then I found if I ran --
insert #t2 select convert(varchar(100),a) from #t1;
It's 'ha' inserted not '0x6861'
I also tried cast(a as varchar(100)).. but still 'ha' not '0x6861'...
Then even select ''||a from #t1 -- will result in 'ha'...
Please kind help me out. Thanks a lot
Regards
Eisen