<div>
what about<br />
<br />
SELECT convert(varbinary(5),12070<wbr />3)
</div>


what about

SELECT convert(varbinary(5),120703)

<div>
the statement <br />
SELECT right(dbo.fn_varbintohexst<wbr />r(Convert(<wbr />varbinary,<wbr /> 120703)),5)<br />
<br />
returns 1d77f (on Sql server 2000)<br />
<br />
- regards<br />
mikkel
</div>


the statement
SELECT right(dbo.fn_varbintohexstr(Convert(varbinary, 120703)),5)

returns 1d77f (on Sql server 2000)

- regards
mikkel

<div>
Hilaire,<br />
your statement gives<br />
0x0001D77F<br />
<br />
mikkelp,<br />
your statement gives<br />
Invalid object name 'dbo.fn_varbintohexstr'.<br />
<br />
Its seems to be a user defined function which is not there in my database.<br />
and yes. I'm using SQL Server 2000
</div>


Hilaire,
your statement gives
0x0001D77F

mikkelp,
your statement gives
Invalid object name 'dbo.fn_varbintohexstr'.

Its seems to be a user defined function which is not there in my database.
and yes. I'm using SQL Server 2000

<div>
it worked !!<br />
<br />
thanks a lot mikkelp.<br />
<br />
There seems to be a lot with these functions in master database that I don't know.<br />
<br />
Thanks again.
</div>


it worked !!

thanks a lot mikkelp.

There seems to be a lot with these functions in master database that I don't know.

Thanks again.

<div>
<div class="content wysiwyg-content">
SELECT convert(varbinary,CONVERT(<wbr />BINARY,120<wbr />703))<br />
RETURNS,<br />
0x000000000000000000000000<wbr />0000000000<wbr />0000000000<wbr />0000000000<wbr />01D77F<br />
<br />
AND I WANT LAST 5 CHARS OF THE RESULT. THAT IS..1D77F<br />
<br />
when I do..<br />
SELECT right(convert(varbinary,CO<wbr />NVERT(BINA<wbr />RY,120703)<wbr />),5)<br />
<br />
It returns me an empty string.
</div>
</div>


SELECT convert(varbinary,CONVERT(BINARY,120703))
RETURNS,
0x00000000000000000000000000000000000000000000000000000001D77F

AND I WANT LAST 5 CHARS OF THE RESULT. THAT IS..1D77F

when I do..
SELECT right(convert(varbinary,CONVERT(BINARY,120703)),5)

It returns me an empty string.

binary to varchar conversion

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.