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

3 votes333 views2 answers
Funktion LOWER/UPPER sql
SQL
1 vote347 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
2 votes343 views1 answer
Sql column values comma separated
SQL
0 vote355 views1 answer
Why we have to set the password for my sql server
SQL
0 vote351 views1 answer
Mysql join only one column
SQL
0 vote379 views1 answer
Dual in db2
SQL
0 vote332 views1 answer
Mysql update sum same table
SQL
0 vote353 views1 answer
Sqlite explain plan
SQL
0 vote372 views1 answer
Mod in sql
SQL
4 votes360 views3 answers
Check if two date ranges overlap sql server
SQL