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 vote182 views2 answers
Update information in a mysql column
SQL
0 vote181 views1 answer
Postgres create database if not exists
SQL
3 votes366 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote222 views1 answer
Mysql auto increment default value with prefix month and year
SQL
10 votes216 views2 answers
Select nextval from sequence oracle
SQL
16 votes213 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote233 views1 answer
Create relationship with betwen two tables in postgersql
SQL
1 vote245 views2 answers
Laravel jwt generate token
SQL
0 vote283 views1 answer
Modificar tipo de dato sql server
SQL
0 vote272 views1 answer
Sqlite display headers on columns
SQL