title: String manipulation SQL
body: <p>I have a row of strings that are in the following format:</p>
  
  <p>'Order was assigned to lastname,firsname'</p>
  
  <p>I need to cut this string down into just the last and first name but it is always a different name for each record.</p>
  
  <p>The 'Order was assigned to' part is always the same.......</p>
  
  <p>Thanks</p>
  
  <p>I am using SQL Server. It is multiple records with different names in each record.</p>