sql server 2016 split string

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

1
2        
3            
4        
5     SELECT 
6    first_name, 
7    last_name,
8    value phone
9FROM 
10    sales.contacts
11    CROSS APPLY STRING_SPLIT(phones, ',');
12

1SELECT SUBSTRING('please notify the sender at the e-mail address above',0,30 +
2charindex(' ',SUBSTRING('please notify the sender at the e-mail address above',31,len('please notify the sender at the e-mail address above')))
3 )
4 as part1,
5 
6 SUBSTRING('please notify the sender at the e-mail address above',30+ charindex(' ',SUBSTRING('please notify the sender at the e-mail address above',31,len('please notify the sender at the e-mail address above'))),len('please notify the sender at the e-mail address above')) as part2