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 vote371 views1 answer
Intellij idea add mysql connector
SQL
3 votes412 views2 answers
See mysql users ubuntu
SQL
1 vote404 views3 answers
How to reset id column in sql server
SQL
0 vote356 views1 answer
Alter table name including schema
SQL
61 votes563 views6 answers
Mysql add column
SQL
1 vote339 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote351 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote368 views2 answers
Postgresql gset
SQL
0 vote328 views1 answer
Format the money fied with comma in international system using sql
SQL
1 vote380 views1 answer
Sql string function update replace
SQL