My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Undocumented conversion of binary variable to a string
The new RSS feed is here
There is an undocumented function in SQL Server for performing the conversion of a binary value into a string representation of the binary value i.e. 0x0233DAF to '0x0233DAF'. You can't just convert to a varchar because the varchar is just the characters representing the ascii values in the binary i.e
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Undocumented conversion of binary variable to a string