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 vote128 views1 answer
Psql datestyle
SQL
0 vote142 views1 answer
Use mysql in java program
SQL
1 vote122 views1 answer
Table infromation in sql server
SQL
0 vote169 views2 answers
Mysql where in maintain order group_concat
SQL
22 votes245 views4 answers
Tsql rename table
SQL
0 vote127 views2 answers
Mysql disable foreign key checks
SQL
13 votes133 views2 answers
Sqlite rename column
SQL
0 vote91 views1 answer
Kannst du deine finger trainieren
SQL
4 votes154 views1 answer
List tables sqlite
SQL
5 votes148 views2 answers
Oracle rename table
SQL