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

1 vote148 views1 answer
Mysql last year
SQL
3 votes172 views2 answers
Oracle drop sequence
SQL
0 vote155 views1 answer
Psql check if sql script is valid
SQL
0 vote145 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
1 vote156 views1 answer
Sql where max date
SQL
0 vote143 views1 answer
Postgres declare variable
SQL
0 vote142 views1 answer
Oracle dynamic select into
SQL
0 vote134 views1 answer
Mysql select all table that have field names
SQL
0 vote129 views1 answer
Output to file mysql
SQL
0 vote199 views1 answer
Restart serial number for postgres
SQL