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 vote158 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote165 views1 answer
Truncate table sql server foreign key
SQL
0 vote183 views1 answer
Sql DATE = GETDATE()
SQL
0 vote176 views1 answer
Repeatable read trong sql server
SQL
1 vote173 views1 answer
Mysql best tutorial for beginners
SQL
4 votes188 views3 answers
Sql find second highest salary employee
SQL
2 votes175 views1 answer
Change primary key sql
SQL
0 vote170 views1 answer
Java spring boot connect to sql server
SQL
0 vote168 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote165 views2 answers
Search stored procedures
SQL