Strip everything between all brackets and parentheses

I need to  strip everything between all brackets and parentheses, including brackets and parentheses so that the ntext BIO displays without that info. I can't seem to find a way to do this correctly using ColdFusion's 'reReplaceNoCase'.

BioInfo.BIO is Datatype ntext
SQL 2000 and ColdFusion 8.
Variable "NAME" is from a FORM post

<CFQUERY NAME="BioInfo" DATASOURCE="BIOFILES">
   SELECT NAME,BIO
   FROM CELEBRITY_BIOS
   WHERE NAME = '#NAME#'
</CFQUERY>

<CFOUTPUT Query="BioInfo">
  #ParagraphFormat(BioInfo.BIO)#
</CFOUTPUT>

Select allOpen in new window

Select allOpen in new window