title: How to return only numbers from query where column is nvarchar
body: <p>I have a simple query that is returning records where "column2" > 0 </p>
  
  <p>Here is the data in the database</p>
  
  <pre><code>Column1          Column2
  1                123456789
  2                123456781
  3                13-151-1513
  4                alsdjf
  5                 
  6                000000000
  </code></pre>
  
  <p>Her is the query</p>
  
  <pre><code> select column1, replace(a.Payroll_id,'-','')
      from table1
      where isnumeric(column2) = 1
  </code></pre>
  
  <p>I'd like to return the following:</p>
  
  <pre><code>Column1          Column2
  1                123456789
  2                123456781
  3                131511513
  </code></pre>
  
  <p>This mean, I won't select any records when the column is blank (or null), will not return a row if it's not an integer, and will drop out the '-', and would not show row 6 since it's all 0.</p>
  
  <p>How can I do this?</p>