SQL

create table split string function in sql server

        
            
        
     SELECT 
    first_name, 
    last_name,
    value phone
FROM 
    sales.contacts
    CROSS APPLY STRING_SPLIT(phones, ',');

sql server split string and insert into table select

SELECT STRING_SPLIT (STRING, SPECIALCHARACTER)