I have a column where the fullname is firstname,lastname format. This column also contains multiple names in firstname,lastname format that are separated by ;. so the example is "John Doe; Jane Doe" etc. I need to create a trigger on the table so that all the new entries from the existing table can be inserted into another table. My trigger works as long as there is no semicolon in it. However I am not sure how to parse two name and then insert them as two rows in firstname, lastname columns in the other table. Any help is greatly appreciated.