strip HTML tags from fields?

Hello,

Does anyone have an easy inline REGEXP_REPLACE() (or equivalent) that will strip out unwanted HTML tags?

I've been trying the following variation, but I suspect that I'm on the wrong path.

SELECT
     regexp_replace (name , '(<.*>).*(<.*>).*(<.*>)' , '\1 \2 \3 ') FROM ... Thanks

Matt Received on Thu Aug 09 2007 - 10:43:18 CDT