title: TERADATA: How do I use position function to return the position of a substring in a string
body: <p>I have a string "Rj 0001 201410212014110301G 20141103ioR4564534 N20141021N 11R" in the table.  I would like to return the value "R4564534" from the string.<br>
  The query I use is:</p>
  
  <p>select SUBSTR(columnX,POSITION('R' IN columnX),8);</p>
  
  <p>but it returns "Rj" instead of "R4564534".<br>
  The result I'd like to get is "R4564534".</p>