title: Split one column into multiple columns in SQL Server
body: <p>I have a table called <code>Employee</code> which has the following column:</p>
  
  <pre><code>FullName
  --------------------
  Holmes, John Henry
  </code></pre>
  
  <p>I want to alter the table and turn <code>FullName</code> into <code>LastName</code>, <code>FirstName</code> and <code>MiddleName</code>. What SQL commands should I use to make this happen? The result I wish to have is this:</p>
  
  <pre><code>LastName    FirstName    MiddleName
  -----------------------------------
  Holmes      John         Henry
  </code></pre>
  
  <p>I have tried youtube videos, forums and articles but to no avail. </p>
  
  <p>Any help would be greatly appreciated as I am just beginning with SQL.</p>