title: splitting a delimited field into separate columns in same record
body: <p>I need to split a pipe-delimited field ('Y|N|Y|Y'). </p>
  
  <p>I found the recursive function listed here
  <a href="https://stackoverflow.com/questions/314824/t-sql-opposite-to-string-concatenation-how-to-split-string-into-multiple-recor">T-SQL: Opposite to string concatenation - how to split string into multiple records</a></p>
  
  <p>but it creates the values into new records.</p>
  
  <pre><code>row   field
   1      Y
   2      N
   3      Y
   4      N
  </code></pre>
  
  <p>I need to transform 'Y|N|Y|Y' </p>
  
  <pre><code>field
  'Y|N|Y|Y' 
  </code></pre>
  
  <p>into </p>
  
  <pre><code>field1  |  field2  | field3  | field4
      y         N         Y        N
  </code></pre>
  
  <p>Can someone point me in the right direction? Would it make it easier if I said the number of values is fixed (it will probably be 8 values delimited in one field).</p>
  
  <p><strong>Update:</strong> A possible field value could be this (note the blank value):
  'Y|10|N|1||Y'</p>