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 vote304 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
17 votes374 views3 answers
Postgresql list users
SQL
0 vote336 views1 answer
Sql last time database was accessed
SQL
0 vote310 views1 answer
Mod function example
SQL
0 vote341 views1 answer
Group by 15 minute interval sql server
SQL
0 vote436 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
36 votes336 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote334 views1 answer
Sql make sure every user is unqiuew
SQL
1 vote322 views1 answer
Oracle sql create view
SQL
13 votes313 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL