Convert Image Type Data to XML/Plain Text in SQL Server

Question

I'm working on SSRS Report.

I have the content with Data type Image. I want to convert it into plain-text or XML. Is it possible?

I am not providing the sample data as there is huge data. (Whole report content saving to image so we can understand)

Suggest me the best solution.

Answer 1

Tried below and working fine but appending extra string like this  to output.

Used RIGHT() to chop off first 3 characters - working fine

SELECT 
RIGHT(CONVERT(VARCHAR(MAX),CONVERT(VARCHAR(MAX),CONVERT(VARBINARY(MAX) ,ImageDataField))),
LEN(CONVERT(VARCHAR(MAX),CONVERT(VARCHAR(MAX),CONVERT(VARBINARY(MAX) ,ImageDataField))))-3)