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

2 votes202 views2 answers
Change mysql password from command line
SQL
0 vote202 views1 answer
Select row from mysql where date more than 30 days
SQL
13 votes204 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
1 vote273 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
2 votes206 views1 answer
Mysql select default if null
SQL
0 vote204 views1 answer
Column ' ' in field list is ambiguous
SQL
8 votes186 views3 answers
Oracle auto_increment
SQL
0 vote228 views1 answer
Renommer schema sql
SQL
0 vote264 views1 answer
Manage Database in MySQL
SQL
0 vote225 views2 answers
Select index table oracle
SQL