title: removing text inside of parentheses in sql then insert that text to different table?
body: <p>I have a column in MS-SQL that contain addresses the users added some additional information pertaining to the address in parentheses. sometimes it is at the end of the address sometimes it is in the middle. I need to remove that text is there a way to remove the text inside the parentheses and then insert it into another table?</p>
  
  <p>for example the text would be      </p>
  
  <pre><code>58795 North Test Drive (Main Office)
  </code></pre>
  
  <p>or it could look like this</p>
  
  <pre><code>450 South green Avenue (Green Ave. Office)  Suite 200
  </code></pre>