title: Function that returns multiple columns
body: <p>I am creating a function that splits up strings. I want to pass the function to a string and get several rows back (the amount of rows would be dynamic depending on the length of the string).</p>
  
  <p>I was thinking of possibly using a table function and joining this to my query.</p>
  
  <p>I am <strong>NOT</strong> asking for this to be written for me, I am simply wondering if this is even possible in SQL Server 2014, and what the best approach would be if it is.</p>
  
  <p>So the string 'ABC' would be returned as:</p>
  
  <pre><code>COL1  COL2  COL3
  A      B    C
  </code></pre>