title: SQL Server 2005 IsNumeric Not catching '0310D45'
body: <p>I've got this value '0310D45'</p>
  
  <p>I'm using isnumeric to check if values are numeric prior to casting to a bigint. Unfortunately this value is passing the isnumeric check.  So my query is failing saying:</p>
  
  <pre><code>Msg 8114, Level 16, State 5, Line 3
  Error converting data type varchar to bigint.
  </code></pre>
  
  <p>What is the simplest way to handle this. I was thinking of using charindex but I would have to check all 26 letters. </p>
  
  <p>Is there a simple solution that I'm not seeing? I really don't want to create a user defined function. </p>
  
  <p>Thanks</p>