Is there a SQL function that can read text from ttxt010 table? If we directly output the text field it will put garbage character,

Arvind

Arvind, you can use search option on the forum for some pointers -

Binary "Text" field in Crystal 7 (http://www.baanboard.com/baanboard/showthread.php?t=24546&highlight=read+text+table)

I just created View for the text table using following SQL and use the new View in all Crystal reports.

SELECT t_ctxt, t_clan, t_seqe, t_text, CONVERT(char(250), t_text)
AS EXPR1
FROM dbo.ttttxt010200

EXPR1 has the text inside. Don't forget to present Views in Crystal along with Tables.

Thank you.

Arvind