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 votes112 views1 answer
Sql find not in list
SQL
1 vote96 views1 answer
Sql select contem uma palavra
SQL
0 vote113 views1 answer
Sp in sql server
SQL
2 votes98 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote104 views1 answer
Ajax error exception handeling
SQL
3 votes109 views1 answer
Sql is not like
SQL
5 votes100 views2 answers
Sql conn
SQL
5 votes103 views4 answers
Select random rows sql
SQL
0 vote113 views1 answer
Helptext in sql
SQL
0 vote103 views1 answer
NLS_NCHAR_CHARACTERSET
SQL