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 vote141 views1 answer
PostgreSQL types and C# types
SQL
0 vote264 views1 answer
Generate a random otp in sql server
SQL
13 votes136 views2 answers
Sqlite rename column
SQL
2 votes134 views2 answers
Join update query in sql
SQL
0 vote144 views1 answer
Drop all procedures sql server
SQL
5 votes129 views1 answer
Mysql add user with all privileges
SQL
4 votes156 views2 answers
Tables in sql
SQL
37 votes143 views3 answers
Duplicate records in sql
SQL
1 vote137 views1 answer
ALL_TAB_PARTITIONS
SQL
5 votes163 views1 answer
Oracle sysdate - 1 month
SQL