title: Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to numeric
body: <pre><code>Select 
      CAST(de.ornum AS numeric) + 1 as ornum2 
  from Cpaym as de
  left outer join Cpaym as de1 on CAST(de.ornum AS numeric) = de1.ornum
  where ISNUMERIC(de.ornum) = 1 
  </code></pre>
  
  <p>I'm trying to get the missing sequence number, but I am getting an error:</p>
  
  <blockquote>
    <p>Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to numeric. </p>
  </blockquote>