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

1 vote288 views1 answer
Encrypt password postgresql
SQL
1 vote273 views1 answer
Mysql select another database
SQL
5 votes273 views1 answer
Oracle nls parameters
SQL
3 votes287 views1 answer
Locate sql server
SQL
18 votes287 views3 answers
Mysql add column default value
SQL
0 vote275 views1 answer
Select odd records sql
SQL
3 votes294 views2 answers
Order by postgresql
SQL
1 vote283 views1 answer
Postgresql how to show table names
SQL
0 vote309 views1 answer
How to find date from date table in sql
SQL
13 votes268 views4 answers
Mysql select last 10 rows
SQL