/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

1 vote307 views1 answer
Select last row from SQL Table
SQL
2 votes365 views2 answers
MySql FULL OUTER JOIN
SQL
1 vote314 views1 answer
Replace all numbers in mysql
SQL
0 vote320 views1 answer
Postgresql port 5432 not open
SQL
0 vote315 views1 answer
Where date major today mysql
SQL
1 vote301 views1 answer
Mysql view command
SQL
1 vote300 views1 answer
Postgresql contains
SQL
0 vote343 views1 answer
Delete hangfire retries list
SQL
0 vote296 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote333 views1 answer
Get statis values sql
SQL