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

26 votes174 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote192 views1 answer
Consulta alias con inner join
SQL
0 vote183 views1 answer
Case insensitive sql
SQL
12 votes192 views5 answers
Rename table in mysql
SQL
0 vote158 views1 answer
Opensuse status MySQL
SQL
7 votes186 views6 answers
Nth highest salary in sql
SQL
1 vote172 views1 answer
Import database from a file using mysql commandline
SQL
1 vote182 views2 answers
Mysql trim spaces
SQL
0 vote172 views1 answer
Mysql cdn link
SQL
1 vote179 views1 answer
Add current timestamp in mysql
SQL