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">
WHERE NAME = '#NAME#'