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 vote198 views1 answer
Inserting data into different tables at once in oracle sql
SQL
4 votes210 views6 answers
List all tables in postgres
SQL
1 vote259 views1 answer
Mysql current running queries
SQL
1 vote214 views1 answer
Pl sql create table from another table
SQL
0 vote288 views1 answer
Postgresql conectar
SQL
0 vote191 views1 answer
Change data type in mysql
SQL
3 votes300 views3 answers
Restart mysql mac
SQL
0 vote198 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote208 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote183 views2 answers
How to start postgresql laravel
SQL