I need to pick up the inconsistent value
<pre><code>select term, dial from #archiving where error_code = '308' 
</code></pre>

<p>Results:</p>

<pre><code>     term                  dial
  011211928433184        211928433184
    2687176073           12687176073
    2687177729           12687177729
0114317862324b7744      4317862324b7744211
  1.16141E+12             1.16141E+12
</code></pre>

<p>I need to exclude term which has exact ten digit numbers other than that I need pick up all inconsistent digits in term. In the end it should look like this</p>

<pre><code> term                     dial
011211928433184        211928433184
0114317862324b7744     4317862324b7744211
  1.16141E+12             1.16141E+12
</code></pre>

<p>Thank you for the help in advance</p>