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 vote297 views1 answer
Mysql backup certain tables workbench
SQL
1 vote298 views1 answer
Oracle select row max date
SQL
0 vote272 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote271 views1 answer
Sql examples from your work
SQL
1 vote275 views1 answer
Sql select where id not exists in another table
SQL
0 vote293 views2 answers
How covert into int in maria db
SQL
0 vote297 views1 answer
Mysql update from select on same table
SQL
-1 vote338 views1 answer
How to Activate the database
SQL
1 vote281 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote310 views2 answers
Sql day from datetime
SQL