How to convert Binary data to text data?

Question

How to convert binary data to text?

I have column called File names in test table with image datatype so when i am selecting the data from test table its showing the data for file names column is binary data i.e ('0x433A5C55736535').

Regards Anji

Solution

I can't beleive nobody answered this. If it's image data you won't get anything readable. but in case it is text data in a binary field, you can do this:

select cast(DataColumn as varchar(MAX)) as DataAsText from [TableWithData];

Comments

[CDahn]

It's the hex representation of binary data.

[Syed Aqeel Ashiq]

I also sometimes get amazed at how SO community behaves. Can somebody explain why a simple, clear, and specific question like this wasn't answered for 7 years?