|
Home > Archive > Microsoft SQL Server forum > June 2005 > Converting binary to text
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Converting binary to text
|
|
| Not Me 2005-06-27, 7:23 am |
| Hey,
Another 'must be simple' question.. I'm wishing to convert a binary
field into a textual representation of that binary data. i.e. come out
with what the query analyser would display, and not try to convert the
binary into ascii/whatever encoded text.
Cheers for any clues,
Chris
| |
| Not Me 2005-06-27, 9:23 am |
| Not Me wrote:
> Hey,
>
> Another 'must be simple' question.. I'm wishing to convert a binary
> field into a textual representation of that binary data. i.e. come out
> with what the query analyser would display, and not try to convert the
> binary into ascii/whatever encoded text.
Sorted now, through the master.dbo.fn_varbintohexstr function... took an
unnatural amount of google-ing tho :)
|
|
|
|
|