title: tsql function split string
body: <p>I wonder if anyone can help me.</p>
  
  <p>I need a tsql function to split a given value such as:</p>
  
  <pre><code>1)    00 Not specified
  3)    01-05 Global WM&amp;BB | Operations
  2)    02-05-01 Global WM&amp;BB | Operations | Operations n/a
  </code></pre>
  
  <p>I need to get a result like this:</p>
  
  <pre><code>cat1  cat1descr       cat2    cat2descr     cat3   cat3descr
  ----------------------------------------------------------------
  00    Not especified  null    null          null   null
  01    Global WM&amp;BB    05      Operations    null   null
  01    Global WM&amp;BB    05      Operations    01     Operations n/a
  </code></pre>
  
  <p>Result will have always 6 columns</p>
  
  <p>select funcX('00 Not specified');</p>
  
  <pre><code>cat1  cat1descr      cat2  cat2descr      cat3  cat3descr
  ----------------------------------------------------------------
  00    Not especified  null  null          null   null
  </code></pre>