title: Add rows to result set from comma delimited data
body: <p>I have a select statement returning data in the following format- (from a bad database design)</p>
  
  <pre><code>ID  Numbers           
  3   6,7,8    
  </code></pre>
  
  <p>and I need to tweak it to return </p>
  
  <pre><code>ID  Number             
  3   6    
  3   7  
  3   8
  </code></pre>
  
  <p>to fix it.  What's the best way to do this? I do not need a permanent function, I just need the result set from a select query to import into a new database.</p>
  
  <p>thanks!</p>