title: Mimic STRING_SPLIT without custom function in SQL Server 2008
body: <p>It is asked many times, but not this way.</p>
  
  <p>I am on SQL Server 2008, and there is no <code>STRING_SPLIT</code> function (like in 2016).</p>
  
  <p>A query returns with the following row, see below a single example row. What you see below in bald is a single field actually, so one <code>varchar</code> column has it altogether:</p>
  
  <pre><code>Appple|10|admin|845687|Apr|26|11:32:29|2016|AwesomeApplication.zip
  </code></pre>
  
  <p>which I'd like to be split by the pipe <code>|</code> character.</p>
  
  <p>I cannot write a CTE for this, or a custom function.</p>
  
  <p>I have to extract the individual pipe delimited elements, into different columns, within one select statement using the built in string functions like <code>CHARINDEX</code>, <code>PATINDEX</code>.</p>
  
  <p>Does anybody have any idea?</p>