title: SQL split based on delimeter, keep only second element
body: <p>I have T-SQL code and am researching how to split </p>
  
  <pre><code>Aruba\abc
  Spain\defg
  New Zealand\qwerty
  Antartica\sporty
  </code></pre>
  
  <p>Such that the column outputs </p>
  
  <pre><code>abc
  defg
  qwerty
  sporty
  </code></pre>
  
  <p>So far, I found something like this,</p>
  
  <p><a href="http://www.aspsnippets.com/Articles/Split-function-in-SQL-Server-Example-Function-to-Split-Comma-separated-Delimited-string-in-SQL-Server-2005-2008-and-2012.aspx" rel="noreferrer">http://www.aspsnippets.com/Articles/Split-function-in-SQL-Server-Example-Function-to-Split-Comma-separated-Delimited-string-in-SQL-Server-2005-2008-and-2012.aspx</a></p>
  
  <p>But it splits column based on delimiters into new columns.</p>
  
  <p>I wish to keep the information AFTER the delimiter <code>\</code></p>
  
  <p>Please advise</p>