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 vote119 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote118 views1 answer
Utiliser sql ligne de commande
SQL
4 votes119 views1 answer
Oracle delete last row
SQL
19 votes119 views3 answers
How to change column type psql
SQL
4 votes130 views3 answers
Drop Table Oracle
SQL
1 vote136 views3 answers
SELECT * FROM
SQL
2 votes137 views1 answer
Postgresql transaction
SQL
0 vote120 views1 answer
Postgres row expiration
SQL
1 vote131 views1 answer
Alter database datafile maxsize 32g
SQL
4 votes108 views3 answers
Sql drop database if exists
SQL