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 vote124 views1 answer
How to to get time in sql
SQL
0 vote109 views1 answer
Access refused mysql xampp server
SQL
0 vote84 views1 answer
Sql query with date
SQL
0 vote115 views1 answer
Sql cheetsheet
SQL
0 vote102 views1 answer
Sort by last two number sql
SQL
0 vote118 views1 answer
Select in select sql
SQL
0 vote123 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
1 vote114 views1 answer
Woocommerce mysql price table
SQL
0 vote125 views1 answer
Postgres clear table
SQL
2 votes119 views2 answers
Mysql search for column name in all tables
SQL