title: Teradata error: The format or data contains a bad character
body: <p>I get the error of "format or data contains a bad character" from the query below.  The datatype of column1 is <code>VARCHAR(2000)</code>.  This is an example of the string <code>'ROC 2236 00 ROC'</code> for column1 and the result I would like to get is <code>'2236.00'</code></p>
  
  <pre><code>SELECT ORDER_NUMBER,
        CASE WHEN COLUMN1 LIKE 'ROC%' THEN CAST(OREPLACE(TRIM(COALESCE(SUBSTR('COLUMN1',5, 8),0)),' ','.' ) AS DEC(12,2) END           
  FROM TABLE1
  WHERE CAST(COLUMN1 AS DEC(12,2)) &gt; 0
  </code></pre>