Thank this author by sharing:
By Florian Reischl, 2009/03/30
This function extends for undocumented Microsoft SQL Server system function fn_varbintohexsubstring to get a hex string for a specified VARBINARY. The Microsoft function is currently restricted for VARBINARY (8000). This function is a wrapper for this function but is able to handle VARBINARY (MAX).
SELECT dbo.udf_varbintohexstr_big(my_image_column) FROM my_table
JOIN-VarBinary
Searching From Varbinary Data Type
CONVERT, VARBINARY, VARCHAR, STRING
Turn varbinary specific bit ON / OFF. Inclde usage samples.
image vs varbinary(max)
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
