Hi All,
I have a table that has one field for contact names. I need to create a new table that splits that field into 3 (FirstName, MiddleIN, LastName). Some contacts have first name only, some have first name middle initial and last name and most have first and last name. How do I handle this?
I have a table that has one field for contact names. I need to create a new table that splits that field into 3 (FirstName, MiddleIN, LastName). Some contacts have first name only, some have first name middle initial and last name and most have first and last name. How do I handle this?