sql server split string from table code example

Example 1: sql server 2016 split string

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

Example 2: sql server split string and insert into table select

SELECT STRING_SPLIT (STRING, SPECIALCHARACTER)