How to extract last and first name from a full name field
Posted on 2009-06-30
I have a field calle fullname with the convention of "Lastname, Firstname" in the varchar field. Example Jones, Bill.
How can I extract just the lastname and then just the firstname?
I want to end up with Bill Jones and I assume I must seperate them first, then concatonate to put them together in desired order.