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 vote284 views1 answer
Sql select most frequent value in group
SQL
0 vote302 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
6 votes305 views3 answers
Update with inner join postgres
SQL
0 vote328 views1 answer
How to get table id sequence postgres
SQL
92 votes548 views6 answers
Substring
SQL
0 vote263 views8 answers
Convert sql query to linq online
SQL
0 vote302 views1 answer
Mysql milliseconds
SQL
0 vote343 views1 answer
Eliminate zero from integer mysql
SQL
0 vote314 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote310 views1 answer
Alter boolean column postgresql
SQL