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

3 votes316 views1 answer
Select without null values sql
SQL
1 vote303 views2 answers
Find a column in all tables mysql
SQL
0 vote298 views1 answer
Mysql show foreign keys column
SQL
3 votes337 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote353 views2 answers
Disallowed function mysql to_date()
SQL
0 vote344 views1 answer
Mysql change default collation
SQL
4 votes307 views2 answers
Mysql show indexes on table
SQL
1 vote306 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote329 views2 answers
Psql commande \gset
SQL
1 vote323 views1 answer
Sql server cast date dd/mm/yyyy
SQL