title: SQL Server delete multiple rows
body: <p>In SQL Server I have a table <code>CustomerAddr</code> and a column named <code>Stnumber</code>. I have non-integer values that I want to delete. I would like to delete the rows of the non-integer values. I use this query that shows the results of the non-integer values:</p>
  
  <pre><code>Select * 
  From [CustomerAddr] [Stnumber] 
  Where ISNUMERIC ([Stnumber]) = 0
  </code></pre>
  
  <p>I use this query:</p>
  
  <pre><code>Delete FROM CustomerAddr 
  WHERE ISNUMERIC StNumber = '0';
  </code></pre>
  
  <p>Unfortunately <code>ISNumeric</code> is the culprit. I receive an error message: </p>
  
  <blockquote>
    <p>An expression of non-boolean type specified in a context where a condition is expected, near 'Stnumber'</p>
  </blockquote>
  
  <p>If I remove <code>isnumeric</code> I can only delete one row at a time.. Help would be great.</p>