title: Remove string between () including () in SQL Server 2008
body: <p>I have a <code>name</code> column which in some of the the cells contains a bracketed string. </p>
  
  <p>Examples:</p>
  
  <pre><code>Smith (Divorced)
  Jones
  Janes
  Renold (Deaceased)...
  </code></pre>
  
  <p>and so on. I need to remove the bracketed section completly.</p>
  
  <pre><code>Smith
  Jones
  Janes
  Renold
  </code></pre>
  
  <p>Tried various <code>CHARINDEX</code>'s and <code>REPLACE</code> but either get an invalid lenght error or it only removes part.</p>