string split can be used on a table column code example

Example: sql server split string and insert into table select

SELECT STRING_SPLIT (STRING, SPECIALCHARACTER)