title: SQL Server: select value, split on a delimiter, then update two columns
body: <p>I have a SQL Server 2008 database table with three varchar Columns - <code>Col1, Col2, Col3</code>.  <code>Col1</code> has data in it with a single space in between, <code>Col2</code> and <code>Col3</code> are empty.</p>
  
  <p>I need to write a query to select the data from <code>Col1</code>, break up each value using the space as the delimiter, and inserting the data on either side of the space into <code>Col2</code> and <code>Col3</code> respectively.</p>
  
  <p>I am not too sure how to proceed. Can this be accomplished in SQL, or should I create a small program to do the work for me? I'd appreciate a pointer in the right direction if this can be accomplished via SQL.</p>
  
  <p>Thanks.</p>