sql server split function 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, ',');