title: How to extract multiple strings from single rows in SQL Server
body: <p>I have e.g. the following table data:</p>
  
  <pre><code>id    |    text
  --------------------------------------------------------------------------------
  1     |  Peter (Peter@peter.de) and Marta (marty@gmail.com) are doing fine.
  2     |  Nothing special here
  3     |  Another email address (me@my.com)
  </code></pre>
  
  <p>Now I need a <strong>select that returns all email addresses from my text columns</strong> (its okay to just check for the parentheses), and that returns more than one row if there are multiple addresses in the text column. I know <a href="https://stackoverflow.com/questions/4793720/how-to-extract-substring-in-mssql">how to extract the first element</a>, but am totally clueless about how to find the second and more results.</p>