How to separate emails by semicolon in SQL Server?

Question

I have a column that has several emails separated by semicolons, I would like to know how to separate these emails and insert separately in another table. In the image below is more detailed.

Answer 1

Just break the emails using STRING_SPLIT and then an Index with the result of SELECT, thus:

INSERT INTO EMAILS(emails)
SELECT A.value AS EMAIL_QUEBRADO
FROM EMAIL X
OUTER APPLY STRING_SPLIT(X.email, ',') AS A