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

6 votes247 views6 answers
Rename column postgres
SQL
1 vote267 views1 answer
Sql to mongodb query converter
SQL
2 votes206 views1 answer
Mysql application.properties spring boot
SQL
0 vote202 views1 answer
Group by sql not ordering issues
SQL
13 votes204 views2 answers
Get date from now() mysql
SQL
2 votes192 views1 answer
Postgresql left join distinct on
SQL
0 vote195 views1 answer
Mysql add comment to column
SQL
2 votes214 views1 answer
How to get weekday from old date in sql
SQL
7 votes201 views2 answers
Create index mysql
SQL
0 vote203 views1 answer
Sql replace id with name from another table
SQL