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 vote426 views1 answer
Delete ids between sql
SQL
0 vote334 views1 answer
Postgresql subquery
SQL
7 votes331 views2 answers
Create mysql user
SQL
0 vote383 views1 answer
SQL check if record exist
SQL
15 votes386 views4 answers
Mysql export database command line
SQL
0 vote366 views1 answer
Sintaxis SELECT sql
SQL
0 vote351 views1 answer
Excute raw query
SQL
0 vote388 views1 answer
How to write if case in select query in select statement
SQL
0 vote389 views1 answer
Default column value in sql same as another column laravel
SQL
2 votes371 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL