title: Finding number position in string
body: <p>Below is what I have in table <code>myTable</code></p>
  
  <pre><code>+++++++++++++++
  + id + myWord +
  +++++++++++++++
  +  1 + AB123  +
  +  2 + A413D  +
  +  3 + X5231  +
  +  4 + ABE921 +
  +++++++++++++++
  </code></pre>
  
  <p>When I execute </p>
  
  <pre><code>SELECT id, Locate('1',myWord) as myPos
  FROM myTable;
  </code></pre>
  
  <p>I get position of 1.</p>
  
  <pre><code>+++++++++++++++
  + id + myPos  +
  +++++++++++++++
  +  1 + 3      +
  +  2 + 3      +
  +  3 + 5      +
  +  4 + 6      +
  +++++++++++++++
  </code></pre>
  
  <p>What I want to achieve is finding first position of integer so that I will have below output.</p>
  
  <pre><code>+++++++++++++++++++++++
  + id + myWord + myPos +
  +++++++++++++++++++++++
  +  1 + AB123  +  3    +
  +  2 + A413D  +  2    +
  +  3 + X5231  +  2    +
  +  4 + ABE921 +  4    +
  +++++++++++++++++++++++
  </code></pre>
  
  <p>Any Idea how I can achieve this?</p>