title: How to parse a string and create several columns from it?
body: <p>I have a <code>varchar(max)</code> field containing Name Value pairs, in every line I have Name UnderScore Value.</p>
  
  <p>I need to do a query against it so that it returns the Name, Value pairs in two columns (so by parsing the text, removing the underscore and the "new line" char.</p>
  
  <p>So from this</p>
  
  <pre><code>select NameValue from Table
  </code></pre>
  
  <p>where I get this text:</p>
  
  <pre><code>Name1_Value1
  Name2_Value2
  Name3_Value3
  </code></pre>
  
  <p>I would like to have this output</p>
  
  <pre><code>Names  Values
  =====  ======
  Name1  Value1
  Name2  Value2
  Name3  Value3
  </code></pre>