title: SQL Select values inside parenthesis
body: <p>I have a column in my table that has the following values</p>
  
  <pre><code>|         loan_no                  |
  
  |  SSS Pensioner Loan (C000000001) |
  |  SSS SSS Loan (C000000002)       |
  |  SSS Salary Loan (C000000007)    |
  |  SSS PAGIBIG Loan (C000000003)   |
  </code></pre>
  
  <p>How can I select only the values inside the parenthesis
  to have an outcome like this:</p>
  
  <pre><code>|  loan_no    |
  
  |  C000000001 |
  |  C000000002 |
  |  C000000007 |
  |  C000000003 |
  </code></pre>
  
  <p>Thank You in advance :)
  I'm using SQL Server 2008 R2</p>