Rich Text

I have a sql database program that has a memo field that contains text that has Rich Text Control Characters embeded into the text. The control characters are at the begining and the end of the field. Is there a way to remove these charatcters?
Thanks,If your data will fit in within a VARCHAR datatype, try CASTing it to VARCHAR first. Then you can do text manipulation on it. Memo fields won't let you.|||I did an analysis of the Rich Text Control Characters and it appears that the ending Characters are "\fs17". I made up the following command that searches the memo field for these characters and then display the remainder of the memo field:

Mid([SUMMARY],(InStr([SUMMARY],'\fs17')+5))

Thanks for the information!