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 vote273 views2 answers
How to check if a column exists in a SQL Server table?
SQL
1 vote221 views1 answer
Postgresql create table with timestamp
SQL
0 vote242 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote208 views1 answer
How to connect to mysql in ef 6
SQL
0 vote228 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
3 votes194 views4 answers
Show columns from table
SQL
3 votes220 views2 answers
Mysql create timestamp column
SQL
0 vote210 views1 answer
Mysql begin statement
SQL
0 vote231 views1 answer
Mssql dockere
SQL
1 vote226 views1 answer
Sysdate in sql
SQL