/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

11 votes206 views2 answers
Having clause in sql
SQL
1 vote209 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote205 views1 answer
Why mysql is used?
SQL
2 votes203 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote216 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote227 views1 answer
How convert into in in sql query
SQL
7 votes213 views2 answers
3rd height salary sql
SQL
0 vote240 views1 answer
Into operator in sql
SQL
0 vote208 views1 answer
Sql select inside select sub query
SQL
5 votes214 views1 answer
Sql integer to serial
SQL