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 vote223 views1 answer
Mysql row generator
SQL
0 vote170 views1 answer
How to check xampp mysql password
SQL
1 vote194 views1 answer
Import mysql dump database command line linux
SQL
5 votes201 views5 answers
Find max number in sql
SQL
0 vote130 views1 answer
Psql not found windows
SQL
0 vote156 views1 answer
Running query in redshift
SQL
2 votes176 views3 answers
Postgresql reset auto increment
SQL
25 votes190 views5 answers
Uninstall mysql ubuntu
SQL
-1 vote172 views1 answer
How to open blade file from blade in laravel
SQL
0 vote162 views1 answer
Mysql multiple count
SQL