title: MS Access/SQL Question: How to split strings?
body: <p>I've a table which looks like this</p>
  
  <pre><code>[name_attr][visted_places_attr]
   peter      zurich paris tokyo
   max        nyc london prague
   max        stockholm
  </code></pre>
  
  <p>The cities are delimited by a white space. If there are more than three cities, they're listed in a new row. I'm trying to figure out how I can get the cities separately (and delimited) in a new table of this form:</p>
  
  <pre><code>[name_attr][visited_place_attr] 
   peter      zurich
   peter      paris
   peter      tokyo
   max        nyc
   max        london
   &lt;...&gt;
  </code></pre>
  
  <p>I Appreciate any input.</p>
  
  <p>Cheers</p>