title: SQL Server 2005 : split string into array and get array(x)?
body: <p>I have strings in a database table like this:</p>
  
  <pre><code>Peter/Parker/Spiderman/Marvel
  Bruce/Wayne/Batman/DC
  </code></pre>
  
  <p>Is there a way in SQL to extract specific values from  a string e.g.</p>
  
  <pre><code>Name = MyColumn(0)
  SurName = MyColumn(1)
  Character = MyColumn(3)
  Company = MyColumn(4)
  </code></pre>
  
  <p>Thanks</p>