title: How to get only numeric column values?
body: <p>Using SQL Server 2005</p>
  
  <p>I want to get only numeric values from the table</p>
  
  <p>Column1</p>
  
  <pre><code>12345
  asdf
  2312
  ase
  acd
  ...,
  </code></pre>
  
  <p>Tried Query</p>
  
  <pre><code>Select Isnumeric(column1) from table
  </code></pre>
  
  <p>Showing Result as</p>
  
  <pre><code>1
  0
  1
  0
  0
  ..,
  </code></pre>
  
  <p>I need the colum1 numeric value</p>
  
  <p>Need SQL Server Query help</p>