title: How to normalize a multi-values in a single field (SQL)
body: <p>I have a table which consists of column names Foo &amp; Bar where Foo is a unique ID and bar contains multi-values seperated by ~</p>
  
  <pre><code>Foo Bar
  1   A~B~
  2   A~C~D
  </code></pre>
  
  <p>I need it to be normalised as such:</p>
  
  <pre><code>Foo Bar
  1   A
  1   B
  2   A
  2   C
  2   D
  </code></pre>
  
  <p>While I can do it from Excel by separating TEXT to Column followed by pivoting, it is not doable as I have 1 million over records and Bar column may contain up to 12 different values.</p>
  
  <p>Is there a simple way which I could manipulate straight from SQL? </p>