do you need 0x4E4E to read 'NN' or '0x4E4E' ?

<div>
I'd need '0x000174F400004FF6000E000<wbr />00000' to read '0x000174F400004FF6000E000<wbr />00000'<br />
<br />
cheers<br />
<br />

</div>


I'd need '0x000174F400004FF6000E00000000' to read '0x000174F400004FF6000E00000000'

cheers



<div>
Then you can use the system function fn_varbintohexstr<br />
<br />
declare @a varbinary(200)<br />
set @a = 0x00FF00FF<br />
<br />
select master.dbo.fn_varbintohexs<wbr />tr(@a)<br />

</div>


Then you can use the system function fn_varbintohexstr

declare @a varbinary(200)
set @a = 0x00FF00FF

select master.dbo.fn_varbintohexstr(@a)


<div>
then check the accepted answer in the link i posted by p_puranik
</div>


then check the accepted answer in the link i posted by p_puranik

<div>
Oops please ignore my post above (same solution than sajuks's post)<br />
My apologies sajuks
</div>


Oops please ignore my post above (same solution than sajuks's post)
My apologies sajuks

<div>
Hilaire no apology needed...i wasnt sure what o/p was to be shown and posted what am currently using.<br />

</div>


Hilaire no apology needed...i wasnt sure what o/p was to be shown and posted what am currently using.


<div>
<div class="content wysiwyg-content">
I realise this question has no doubt been asked and answered many times, however I'm asking it anyway.<br />
<br />
I need to convert a varbinary data type to Varchar so the results are viewable to certain applications we run that cannot read binary.<br />
<br />
Many thanks
</div>
</div>


I realise this question has no doubt been asked and answered many times, however I'm asking it anyway.

I need to convert a varbinary data type to Varchar so the results are viewable to certain applications we run that cannot read binary.

Many thanks

Varbinary to Varchar

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.