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 vote153 views1 answer
Set a default value for a column in sqlite
SQL
36 votes154 views3 answers
Finding duplicate column values in table with sql
SQL
8 votes171 views2 answers
Select current_timestamp - interval '3 days';
SQL
-1 vote156 views3 answers
Psql get last rows
SQL
1 vote150 views1 answer
Mysql alter decimal precision
SQL
0 vote153 views1 answer
Excel export from sql using python
SQL
0 vote177 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote139 views1 answer
Sql right characters
SQL
0 vote158 views1 answer
Oracle cpu metric
SQL
0 vote221 views1 answer
Mariadb date equals to current_date plus days
SQL