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 vote241 views1 answer
ORA-00942
SQL
0 vote174 views1 answer
Set mysql socket file docker windows
SQL
0 vote159 views3 answers
Database restoring error
SQL
3 votes157 views2 answers
Postgres show table schema
SQL
1 vote167 views1 answer
Quit mysql
SQL
-1 vote161 views1 answer
Phinehas Psalm 106
SQL
0 vote165 views1 answer
Create dump file mysql workbench
SQL
4 votes185 views5 answers
Get last query in codeigniter 4
SQL
0 vote155 views1 answer
Change date format in oracle query
SQL
1 vote163 views1 answer
Tsql find foreign key references
SQL