title: Select only integers from char column using SQL Server
body: <p>How can I write a select statement to select only integers (and nothing more) from a char column in SQL Server. For example, my table name is POWDER with 2 columns, ID (int) and Name(char (5)) </p>
  
  <pre><code>ID     Name
  -- ----------
  1     AXF22
  2     HYWWW
  3     24680
  4     8YUH8
  5     96635
  </code></pre>
  
  <p>I want to be able to select only those rows that contain an integer and nothing more (ID 3 and ID 5 in this example)</p>
  
  <p>If I try:</p>
  
  <pre><code>SELECT * 
    FROM POWDER
   WHERE Name LIKE '[0-9]%'
  </code></pre>
  
  <p>...it will return:</p>
  
  <pre><code>ID     Name
  --    ----------
  3      24680
  4      8YUH8
  5      96635
  </code></pre>
  
  <p>Any ideas how to get the rows containing just integers?</p>