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 vote145 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote169 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote160 views1 answer
Oracle string length
SQL
0 vote159 views1 answer
Mysql regex select
SQL
0 vote143 views2 answers
Oracle create chain rule
SQL
0 vote176 views3 answers
Call to undefined function mysql_connect()
SQL
12 votes158 views4 answers
How to check mysql version ubuntu
SQL
24 votes139 views2 answers
Alter table delete column
SQL
0 vote137 views1 answer
Restart sql server command line linux
SQL
1 vote156 views2 answers
Mysql update table from another table
SQL