title: SQL Server: finding the bad data
body: <p>How do I select all rows except for ones that where I get an error calling <code>CONVERT</code> on one of the columns?</p>
  
  <p>For example, I am doing this:</p>
  
  <pre><code>SELECT rowid 
  FROM batchinfo 
  WHERE CONVERT(DATE, reporttime, 101) between '2010-07-01' and '2010-07-31';
  </code></pre>
  
  <p>And I am getting errors for some of the values.  I have two questions:</p>
  
  <ol>
  <li>How can I skip the rows that have errors?</li>
  <li>How can I get <em>only</em> the rows that have errors?</li>
  </ol>