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 vote207 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote200 views2 answers
Create sequence if not exists postgres
SQL
0 vote195 views1 answer
Porcentaje sql
SQL
0 vote206 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote207 views1 answer
How to use select union and loop
SQL
1 vote230 views1 answer
Drop primary key oracle
SQL
1 vote227 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
1 vote192 views1 answer
Funzioni plsql
SQL
1 vote211 views1 answer
Use of now() in mysql
SQL
2 votes215 views1 answer
Use cases condition in sql query laravel
SQL