I need help on writing a SQL query. I have a table field that contains email addresses separated by semicolons. Some of the addresses are fully qualified addresses while others are outlook email groups. I would like to get a count of the number of email groups and replace them with fully qualified addresses (eg. firstname.lastname@example.org
Please provide me any suggestions you may have. I will appreciate your help.