title: How to order by last name on a full name column?
body: <p>I have a SQL Table with a column called FullName which contains, for example, "John Smith".</p>
  
  <p>How can order the data by the last name that appears in the FullName column?</p>
  
  <p>For a long name like "Laurence John Fishburne", I would like to order the data by the word "Fishburne".</p>
  
  <p>Thus, names are stored in the order</p>
  
  <ul>
  <li>First Name</li>
  <li>Middle Names</li>
  <li>Last Name</li>
  </ul>
  
  <p>I am using Microsoft SQL Server 2005.</p>