title: SQL Join on split?
body: <p>I'd like to perform a join on a column which contains a value I would like to split on. So if the column contained email addresses I would like to join on the part before the "@" symbol.</p>
  
  <p>I have seen the split function, but I didnt see anywhere I could choose which array element to pick from the result of the split?</p>
  
  <p>So something like:</p>
  
  <pre><code>JOIN ON dbo.split('@',T1.Column)(0)?
  </code></pre>