title: Teradata POSITION with occurrence
body: <p>In MySQL DB, this is the query:</p>
  
  <pre><code>SELECT LOCATE(BINARY 'st','myteststring',6); 
  output: 7
  </code></pre>
  
  <p>In Teradata, how can I achieve the same?</p>