title: SQL CLR return two new columns
body: <p>I have a SQL CLR function which at the moment returns a string seperated by a comma.</p>
  
  <p>How would I code the statement to return two new columns into my resultset.</p>
  
  <p>For example</p>
  
  <pre><code>Select A, B, MyCLRFunction(X,Y) C From MyTable
  </code></pre>
  
  <p>Returns:-</p>
  
  <pre><code>One    Two    Three,Four
  Five   Six    Seven,Eight
  </code></pre>
  
  <p>I would want it to return :-</p>
  
  <pre><code>One    Two    Three    Four
  Five   Six    Seven    Eight
  </code></pre>