create manually string split function sql server code example

Example 1: sql server 2016 split string

SELECT value FROM STRING_SPLIT('Lorem ipsum dolor sit amet.', ' ');

Example 2: create table split string function in sql server

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