SQL Select values inside parenthesis
<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>