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 vote135 views1 answer
Initcap in mysql
SQL
2 votes142 views2 answers
Create empty table from existing table
SQL
10 votes142 views2 answers
SQL rounding numbers
SQL
0 vote132 views1 answer
Sql get number of days between two dates
SQL
0 vote132 views1 answer
Show function mysql
SQL
0 vote127 views1 answer
Get who is hired in specific month in sql
SQL
0 vote147 views1 answer
Default column value in sql same as another column laravel
SQL
22 votes118 views2 answers
Mysql show all tables
SQL
0 vote130 views1 answer
T-sql email validation
SQL
1 vote123 views1 answer
Sql only five first row
SQL