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

6 votes341 views3 answers
Create database mysql utf8
SQL
1 vote331 views2 answers
Maximum number of tables in mysql
SQL
0 vote339 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote316 views1 answer
Postgresql on conflict pair
SQL
0 vote338 views1 answer
How to create notes in mysql
SQL
1 vote306 views1 answer
Sql run multiple updates in one query
SQL
0 vote301 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
5 votes346 views2 answers
Functions
SQL
0 vote305 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote340 views1 answer
Sql sort ages
SQL