title: How to extract everything after parentheses in BigQuery?
body: <p>How can I extract all the characters after the first word?</p>
  <p>For example, I would like to have <code>(084M)</code> in its own column with the parentheses included. I've tried to <a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#split" rel="nofollow noreferrer"><code>SPLIT</code></a> and <a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_extract" rel="nofollow noreferrer"><code>REGEXP_EXTRACT</code></a> but I have ran into issues.</p>
  <p><strong>Table</strong>:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Name</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Elizabeth (084M)</td>
  </tr>
  <tr>
  <td>Elizabeth (084M)</td>
  </tr>
  <tr>
  <td>Elizabeth (084M)</td>
  </tr>
  <tr>
  <td>Pittston (14KN)</td>
  </tr>
  <tr>
  <td>Pittston (14KN)</td>
  </tr>
  <tr>
  <td>Pittston (14KN)</td>
  </tr>
  <tr>
  <td>Cheektowaga (14ON)</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p><strong>Image of Table</strong>:<br />
  <a href="https://i.stack.imgur.com/DwBEH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DwBEH.png" alt="enter image description here" /></a></p>