title: How to parse a numeric value in a string?
body: <p>Teradata question. I need to <code>select</code> those rows that have more than 4 consecutive digits for column <code>mycolumn</code></p>
  
  <p>I tried the following</p>
  
  <pre><code>SELECT  id, SUBSTR( mycolumn, ((POSITION( '3' IN CHAR2HEXINT(TRANSLATE( mycolumn USING UNICODE_TO_LATIN) ))/2)+1),  5) mycolumndigits
  FROM mytable
  WHERE TRIM(mycolumndigits+' ') LIKE '_ _ _ _ _ '
  </code></pre>
  
  <p>Sometimes I would get an untranslatable character exception, other time bad characted exception</p>
  
  <p>Please help me to improve it</p>
  
  <p><em>(PS: I am not allowed to use Oracle functions (otranslate etc.). Also i cannot create stored procedures and functions. DBA won't give me access)</em></p>