title: Remove text within parenthesis in SQL
body: <p>I'm trying to remove parenthesis and text within it. 
  Eg: Column1 has data and cleaned data should look like column2</p>
  
  <pre><code>Column1       Column2
  HF(abcd)      HF
  BP(234)       BP
  ATRS (2354)   ATRS
  AB(PS) SD(12) AB SD
  </code></pre>
  
  <p>I'm trying to use the below regex just to view the cleaned data, But I'm doing it wrong</p>
  
  <blockquote>
    <p>s/([^)]*)//</p>
  </blockquote>
  
  <pre><code>select Column1 from table where Column1 like '%s/\([^)]*\)//%'
  </code></pre>
  
  <p>What is the best possible solution for this</p>