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 vote329 views1 answer
Check if database exists sql
SQL
7 votes320 views1 answer
Safe mode mysql
SQL
-1 vote357 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote323 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
1 vote542 views2 answers
Sql unique rows
SQL
13 votes318 views4 answers
Mysql select last 10 rows
SQL
0 vote315 views1 answer
Database springboot
SQL
15 votes345 views2 answers
Select where duplicate mysql
SQL
1 vote338 views2 answers
Mssql show database size
SQL
0 vote324 views1 answer
How to change the field size of an existing column
SQL