/SQL/Fetch second word from a string in ms sql

Fetch second word from a string in ms sql

-- Example there is a column FULL_NAME which contains two words like "Bob Dylan"
-- To fetch second word "Dylan" we will use space as a divisor 
-- and take 10 signs after space
SELECT SUBSTRING(FULL_NAME, (SELECT CHARINDEX(' ', FULL_NAME)+1), 10) 
FROM TABLE_NAME;

Similar codes

2 votes299 views1 answer
When matched in sql server
SQL
2 votes260 views1 answer
Oracle sql drop column if exists
SQL
0 vote311 views1 answer
Date datatype in livesql
SQL
7 votes312 views1 answer
Query postgres delete duplicates
SQL
5 votes298 views1 answer
Oracle asynchronous update
SQL
2 votes288 views1 answer
Get first n letter of department name in sql
SQL
6 votes315 views3 answers
How to delete table sqlite
SQL
0 vote317 views1 answer
Cahnge column name apex oracle
SQL
12 votes302 views10 answers
Google
SQL
16 votes368 views2 answers
Sql vs nosql
SQL