title: how to split a string by space in SQL
body: <p>I have a string like this:
  'My name is Jason Fernandez.'</p>
  
  <p>Strings separated by speace have different lengths.
  I want to get each of the strings separated by space, which means I want to have 5 different items as a result.</p>
  
  <pre><code>1 my
  2 name
  3 is
  4 Jason
  5 Fernandez
  </code></pre>
  
  <p>I am using SQL server 2008.</p>
  
  <p>Thank you.</p>