title: SQL invalid conversion return null instead of throwing error
body: <p>I have a table with a varchar column, and I want to find values that match a certain number.  So lets say that column contains the following entries (except with millions of rows in real life):</p>
  
  <pre><code>123456789012
  2345678
  3456
  23 45
  713?2
  00123456789012
  </code></pre>
  
  <p>So I decide I want all the rows which are numerically 123456789012 write a statement that looks something like this:</p>
  
  <pre><code>SELECT * FROM MyTable WHERE CAST(MyColumn as bigint) = 123456789012
  </code></pre>
  
  <p>It should return the first and last row, but instead the whole query blows up because it can't convert the "23 45" and "713?2" to bigint.</p>
  
  <p>Is there another way to do the conversion that will return NULL for values that can't convert?</p>