title: Finding strings with duplicate letters inside
body: <p>Can somebody help me with this little task? What I need is a stored procedure that can find duplicate letters (in a row) in a string from a table "a" and after that make a new table "b" with just the id of the string that has a duplicate letter.</p>
  
  <p>Something like this:</p>
  
  <p><strong>Table A</strong></p>
  
  <pre><code>ID Name   
  1  Matt
  2  Daave
  3  Toom
  4  Mike
  5  Eddie
  </code></pre>
  
  <p>And from that table I can see that <code>Daave</code>, <code>Toom</code>, <code>Eddie</code> have duplicate letters in a row and I would like to make a new table and list their ID's only. Something like: </p>
  
  <p><strong>Table B</strong></p>
  
  <pre><code>ID     
  2
  3
  5
  </code></pre>
  
  <p>Only 2,3,5 because that is the ID of the string that has duplicate letters in their names.</p>
  
  <p>I hope this is understandable and would be very grateful for any help.</p>