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

11 votes162 views2 answers
Set default column value sql
SQL
0 vote190 views1 answer
Sql select max value for each group
SQL
2 votes135 views5 answers
SQL trigger
SQL
1 vote126 views1 answer
SQL date part only of datetime
SQL
0 vote138 views1 answer
Mysql average from two table
SQL
0 vote214 views1 answer
Install ms sql server management studio
SQL
1 vote133 views3 answers
Mysql parse int
SQL
4 votes165 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote125 views1 answer
Drop tables from local database postgres pgadmin
SQL
3 votes121 views2 answers
Laravel tosql with bindings
SQL