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 vote119 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote115 views1 answer
On sql table data exists
SQL
0 vote103 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
5 votes122 views2 answers
To date oracle
SQL
0 vote114 views2 answers
Getting customers with no orders sql
SQL
-1 vote103 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
0 vote128 views3 answers
Join
SQL
7 votes107 views1 answer
Sql disable safe mode
SQL
4 votes101 views2 answers
Postgresql reset sequence
SQL
0 vote114 views1 answer
Mysql count with two joins
SQL