SQL Function to convert RTF to plain text

[rob.kellington at gmail]

Does anyone have the logic to convert RTF formatted data in a text
column into plain ascii text that I can use in a varchar variable or
field?

We have an app that allows formatted comments/notes to be stored in a
SQL 2000 text column. Ideally, I would like a trigger that would copy
any inserted comments into a seperate table, varchar field so that
these are viewable in other apps that can not display formatted RTF.

I would really like the logic to be all SQL based and not have to use a
client app to read/convert/insert the data in a batch mode.

[John Bell]

Hi

If you can get plain text out of the application/control then that will be
the quickest and simplest solution. As rtf format control codes are ascii
you could search and replace the control codes but there are many of them!

John

"rob.kellington at gmail" <ro************@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Does anyone have the logic to convert RTF formatted data in a text
column into plain ascii text that I can use in a varchar variable or
field?

We have an app that allows formatted comments/notes to be stored in a
SQL 2000 text column. Ideally, I would like a trigger that would copy
any inserted comments into a seperate table, varchar field so that
these are viewable in other apps that can not display formatted RTF.

I would really like the logic to be all SQL based and not have to use a
client app to read/convert/insert the data in a batch mode.