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

3 votes216 views1 answer
Sql online test questions and answers
SQL
0 vote188 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote189 views1 answer
Sql server remove primary key without dropping table
SQL
1 vote217 views1 answer
Insert value to new table by joining 2 different tables
SQL
1 vote190 views1 answer
Sql current timestamp
SQL
1 vote205 views1 answer
Sql string function update replace
SQL
0 vote198 views1 answer
Postgresql where clause not working
SQL
1 vote193 views1 answer
Sql headers delphi
SQL
0 vote196 views1 answer
Postgresql create user roles
SQL
10 votes207 views4 answers
Else if mysql
SQL