title: Substr in reverse direction
body: <p>I am trying to get the numbers from a numerics field (which is mostly 8 characters long) from the last digit back to 6 digits in reverse direction. E.g</p>
  
  <pre><code>2345678-- i want 345678
  56789356--789356
  </code></pre>
  
  <p>I am using the below code:</p>
  
  <pre><code>sel SUBSTRING( LEVN010  from character_length(LEVN010)-5 for   6 )  FROM X.TABLE
  </code></pre>
  
  <p>But, this is not working. Any solution for this is much appreciated.</p>
  
  <p>Thanks,
  Amit</p>