title: String operation in SQL to reverse a string
body: <p>In DB2 9.7 I am looking for a way to reverse a string in a SQL query.</p>
  
  <p>I am familiar with SQL Server where the query would be like</p>
  
  <pre><code>SELECT
      REVERSE(LEFT_TO_REIGHT) AS RIGHT_TO_LEFT
  FROM 
      TABLE1;
  </code></pre>
  
  <p>I couldn't find a similar function in DB2. is there a simple way to reverse a string?</p>