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

1 vote251 views1 answer
Mysql monthname
SQL
3 votes251 views3 answers
Stop mysql ubuntu
SQL
0 vote258 views1 answer
Basic structure of sql expression having clause
SQL
0 vote251 views1 answer
What is between operator
SQL
4 votes298 views1 answer
Ms sql truncate table vs delete
SQL
1 vote253 views1 answer
Deleting database in sql
SQL
0 vote276 views1 answer
Table user postgres
SQL
4 votes297 views3 answers
Postgres drop all tables
SQL
0 vote261 views1 answer
Mysql date format unix timestamp
SQL
0 vote262 views1 answer
Update and keep original value sql
SQL