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

2 votes204 views2 answers
Postgresql get table names
SQL
0 vote191 views1 answer
Mariadb search columns
SQL
1 vote184 views1 answer
Can we drop a primary key
SQL
6 votes181 views2 answers
How to copy data in sql
SQL
0 vote192 views1 answer
Create database store
SQL
0 vote262 views2 answers
How to take recent row without limit in mysql
SQL
5 votes233 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote193 views1 answer
Why mysql is used?
SQL
0 vote200 views1 answer
Add a new column into table
SQL
0 vote207 views1 answer
Snowflake drop column
SQL