Sql split string by space

SELECT SUBSTRING('please notify the sender at the e-mail address above',0,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')))
 )
 as part1,
 
 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

Source: forums.asp.net

Create table split string function in sql server

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

Source: sqlservertutorial.net

Similar codes

0 vote183 views1 answer
Postgres drop type
SQL
15 votes192 views4 answers
Create table if not exists sql
SQL
0 vote180 views1 answer
Mysql set column equal to another automatic
SQL
1 vote182 views1 answer
Mamp mysql path mac
SQL
1 vote325 views3 answers
Uninstall postgresql mac
SQL
0 vote207 views1 answer
Hallo
SQL
22 votes198 views3 answers
Year format in date mysql
SQL
1 vote232 views2 answers
Login to mysql
SQL
0 vote195 views1 answer
Drop view in mysql
SQL
1 vote199 views1 answer
Mysql add fields
SQL