title: How do I split a delimited string so I can access individual items?
body: <p>Using SQL Server, how do I split a string so I can access item x?</p>
  
  <p>Take a string "Hello John Smith". How can I split the string by space and access the item at index 1 which should return "John"?</p>