I am using an ADODB recordset with VBScript in my .ASP page on a sql server 2000 to query a memo field in my SQL database that contains Rich Text formating.

How can I strip these Rich Text formating codes from my data field to display straight text?

I have found reference to a "rtf reader" on the MSDN Website, but I don't know a) If I have access to this function within my VBScript code and/or b) How to use this function in my VBScript code.

Am I barking up the right tree? Or do I really have to write my own stripping logic?

Thanks in advance for any ideas/suggestions!!!!

MY CODE:
SET ado_rec=Server.CreateObject("ADODB.Recordset")
odbc_fn="FILEDSN=c:\Program Files\Common Files\ODBC\Data Sources\sponsor.dsn"
ado_rec.Open sql_ado, odbc_fn, 2, 3
Do While NOT ado_rec.EOF
Response.Write("<tr height='1px' bgcolor='gray'><td colspan='3'> </td><tr>")
Response.Write("<tr><td> " &ado_rec("HI_DATE") & "</td>")
Response.Write(" <td> " &ado_rec("HI_SUBJECT") & "</td>")
Response.Write(" <td> " &ado_rec("HI_CREATOR") & "</td><tr>")
Response.Write("<tr><td colspan='3'> " &ado_rec("NO_NOTE") & "</td><tr>")
ado_rec.MoveNext
Loop
ado_rec.Close
Set ado_rec=Nothing

RESULT of ado_rec("NO_NOTE"):
{\rtf1\ansi\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS Sans Serif;}{\f1\fnil MS Sans Serif;}} \viewkind4\uc1\pard\f0\fs20 I called and spoke to Jill today. They are real slow right now, but will be adding on people after January 3rd. I will order coupons and I have a sign up scheduled for January 12th from 1:30 to 2:30. Terri\f1\par }

DESIRED RESULT:
I called and spoke to Jill today. They are real slow right now, but will be adding on people after January 3rd. I will order coupons and I have a sign up scheduled for January 12th from 1:30 to 2:30. Terri

MSDN REFERENCE ARTICLE:
(http://msdn.microsoft.com/library/de...rtfspec_46.asp)
"rtfreadr.c...
...the function ecRtfParse separates text from RTF controls and handles text, and the function ecParseRtfKeyword parses an RTF control and also collects any parameter that follows the RTF control."

The code examples provided in this article look like C++ or VB, so I don't know if I can use with VB Script...?

Again, Thank you for any ideas/suggestions!!!!