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 votes227 views1 answer
Set column to not null mysql
SQL
4 votes238 views3 answers
Mysql get column names from table
SQL
0 vote234 views1 answer
Find usage of table in sql server
SQL
0 vote227 views3 answers
Postgresql allow remote connections
SQL
-1 vote236 views4 answers
Restart mysql server ubuntu
SQL
27 votes241 views5 answers
Mysql set password for user
SQL
0 vote230 views1 answer
Foreign key multiple columns
SQL
0 vote219 views1 answer
Postgresql create table with boolean column
SQL
2 votes230 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
1 vote221 views3 answers
How to truncate table with foreign key constraint
SQL