Hi,
we have a field under nText which contains both text and RTF text!(database
design and app are by another company, no way to modify them)

simple select query returns normal values under text data, but when it is
RTF we get unnecessary info such as:

{\rtf1\ansi\ansicpg1252\deff0\deflang4105{\fonttbl{\f0\fnil\fcharset0
Arial;}}
\viewkind4\uc1\pard\lang1033\ul\b\fs24 This is a test: entered text
\par
\par second line
\par

infact, all we want to see is:

This is a test: entered text
second line

any idea?

Thanks,
Vaf