title: SQL Server remove leading 0's and all characters after digits
body: <p>Hey I'm a java dev guys so I normally don't do this so bear with me.</p>
  
  <p>I have a column in a table that looks like </p>
  
  <pre><code>Column
  001 - test
  012 - test 2
  </code></pre>
  
  <p>I need those values to look like like below when I do a select:</p>
  
  <pre><code>1
  12
  ...
  ...
  </code></pre>
  
  <p>Thanks in advance</p>