Hi,

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. [email protected]).

Please provide me any suggestions you may have. I will appreciate your help.

Please provide a variety of sampe data, some with groups, some with individual email addresses, etc.