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 vote255 views1 answer
Login phpmyadmin without password
SQL
8 votes287 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote237 views1 answer
Duplicate foreign key constraint name
SQL
0 vote260 views1 answer
Mysql start of today
SQL
2 votes255 views1 answer
Sqlite indexes
SQL
1 vote300 views1 answer
Nvl postgres
SQL
3 votes290 views6 answers
Jwt laravel
SQL
1 vote273 views1 answer
ORA-01950
SQL
0 vote281 views1 answer
Create table with primary key and foreign key in sql server
SQL
0 vote276 views1 answer
Group by two columns postgres
SQL