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

3 votes313 views1 answer
Sql several or
SQL
5 votes357 views2 answers
Postgresql add not null constraint
SQL
2 votes453 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote315 views1 answer
Oracle lowercase
SQL
1 vote335 views1 answer
Psql autocomplete for mac brew install
SQL
18 votes344 views6 answers
Creating table in MySQL
SQL
0 vote335 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote299 views2 answers
Postgresql could not start server mac
SQL
4 votes325 views2 answers
Mysql show indexes on table
SQL
0 vote327 views1 answer
Recover deleted data from mysql database
SQL