Could you guys please give advice or help to resolve my issue:

I use SQL 2005 Reporting services to generate BAAN reports
These reports are based on SQL views I create in the SQL database (SQL2000).

My problem is this - I need to display custom item text in my report which is located in tttxt010.t_text, but this is stored in a binary format and only shows as 'Binary data' in the result set.

How do I convert or extract this binary data so it can be displayed as normal text?

BAAN support suggested purchasing BAAN OPEN WORLD ADAPTER which I don’t have a budget for

Thank you in advance

SELECT cast(t_text AS varchar(240)) as rtxt FROM ttttxt010321

Hitesh, you are truly a Guru
It works like a charm

Thanks
Marius