MSSQL stored procedure to remove RTF Formating from column.

I have a stored procedure that loads a query. One of the cols is a varchar that hold some text that is formatted with RTF. I need the stored procedure to use a regexp to remove the RTF formatting and leave me with a plain text field. Orig col CommentBuffer = " {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Courier New;}} {\colortbl ;\red8\green0\blue0;} {\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\cf1\f0\fs20 8am Start and Delivery for Wednesday 1/15 - Please deliver RT59927A @ same time\par \par LVT lower level living\par S/V in bathroom\par take-up carpet install\par \par } " NewCommentBuffer with RTF formatting removed. NewCommentBuffer = " 8am Start and Delivery for Wednesday 1/15 - Please deliver RT59927A @ same time LVT lower level living S/V in bathroom take-up carpet install " I need to add this to my stored procedure. Please provide the code to add to the stored procedure. HERE IS THE STORED PROCEDURE. THE COL I AM CONVERTING IS h.CommentBuffer. I need to save it to the table without the RTF formatting.