title: I need to pick only first 10 character other than that I want to exclude it
body: <p>Query I am using is this.</p>
  
  <pre><code>select orig, term, dial
  from rej
  where `company = 'goog' and code = '301' and left(term,3) = '011'`
  and dial in (select substring(dial, 0, 11) from rej)
  
     orig             term                 dial       
  4046591010         0112489826790      2489826790 
  9546674396         0115743064558      5743064558  
  4844410151         0113537124         3537124
  8588763590         0113653            4653 
  </code></pre>
  
  <p>I need only "dial" only with 10 digits there inconsistent character into this column which I don't need. 
  After getting this I need to remove the 011 from term then
  so in the end it should look like</p>
  
  <pre><code>   orig             term                 dial       
  4046591010         2489826790         2489826790 
  9546674396         5743064558         5743064558
  </code></pre>
  
  <p>Thank you for the help in advance.</p>