title: How to split a string in T-SQL?
body: <p>I have a <code>varchar @a='a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p'</code>, which has <code>|</code> delimited values. I want to split this variable in a array or a table.</p>
  <p>How can I do this?</p>