title: How to select only records that have number in column (SQL)
body: <p>Basically I want to do this:</p>
  
  <p>I want to return a record set converting one nvarchar value (ID) to an integer if it contains a number.  If ID can be converted to a number, then add that row to the <code>SELECT</code> record set.  If not, skip that row.  </p>
  
  <p>I think the SQL should look something like this.</p>
  
  <p>(ID is nvarchar(10)  in dbo.Table)</p>
  
  <pre><code>CREATE TABLE #Temp  (ID int)
  INSERT INTO #Temp SELECT ID FROM Table Where ISNumeric(Id)=0
  </code></pre>
  
  <p>But I get an error:  nvarchar value 'Default' to data type int.  If I do a <code>SELECT CAST(ID as int)</code> that does not work either. </p>