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 vote221 views2 answers
Show slave status mysql
SQL
0 vote230 views2 answers
How to type a blank discord messgae
SQL
7 votes232 views2 answers
Mysql db size
SQL
2 votes266 views2 answers
Mysql does sentence contain word
SQL
1 vote238 views2 answers
How to add amount between date in sql
SQL
2 votes240 views1 answer
SELECT INTO
SQL
0 vote213 views1 answer
Clone table structure mysql
SQL
0 vote230 views2 answers
Insert into
SQL
2 votes187 views1 answer
Sql float to int
SQL
1 vote243 views2 answers
Select into temp table
SQL