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 vote287 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote260 views1 answer
Database springboot
SQL
0 vote458 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote300 views1 answer
Sqlalchemy empty table
SQL
1 vote291 views1 answer
Vagrant mysql downgrade version
SQL
2 votes286 views1 answer
Tsql copy table
SQL
0 vote269 views1 answer
Sql server udf performance
SQL
0 vote238 views1 answer
Plsql trigger insert update
SQL
23 votes300 views4 answers
Uninstall postgresql ubuntu
SQL
1 vote269 views2 answers
Update with inner join sql server
SQL