W wxdqz New Member Aug 21, 2008 #1 i have a table with a name field containing the last and first name, seperated by a comma, e.g. "Smith, John" (because some idiots had no database experiance). now i need to split this content to two columns: "first" and "last". how can i?
i have a table with a name field containing the last and first name, seperated by a comma, e.g. "Smith, John" (because some idiots had no database experiance). now i need to split this content to two columns: "first" and "last". how can i?
