title: Split Full Name with Format: {Last, First Middle} Comprehensive Cases
body: <p>My client sent me name data as a Name string which includes the last, first, and middle names in a single entry. I need them split into LastName, FirstName, and MiddleName. I have found some scripts online, but they don't serve my purposes because they either (1) use a different format, or (2) don't handle edge cases very well. See the examples below: </p>
  
  <ol>
  <li>Nightingale, Florence -> Florence Nightingale</li>
  <li>Bond, James Bond -> James Bond Bond</li>
  <li>Abbott, Edwin A. -> Edwin A. Abbott</li>
  </ol>
  
  <p>Can someone help me write a SQL Server script that splits a string into the various pieces I'm looking for? </p>