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

4 votes215 views1 answer
Alter session set nls_date_format
SQL
7 votes162 views3 answers
How to check table name in current database sql
SQL
60 votes534 views6 answers
Add column in sql
SQL
5 votes163 views2 answers
Postgre insert select
SQL
0 vote212 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote158 views6 answers
Unique key in sql
SQL
0 vote170 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote164 views1 answer
Add sqlite3 in lumen
SQL
0 vote166 views1 answer
Search db for table name
SQL
1 vote221 views1 answer
Sqlite create index
SQL