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 vote175 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote170 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
4 votes173 views1 answer
Sql any
SQL
-2 votes192 views2 answers
Union all in sql
SQL
5 votes187 views2 answers
Oracle find all tables with column name
SQL
0 vote231 views1 answer
Change redo log file size in mysql 5.6
SQL
1 vote148 views1 answer
Strict in postgres SQL
SQL
-1 vote128 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote182 views4 answers
How to drop all tables in sql
SQL
1 vote181 views1 answer
Date_part mysql
SQL