/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

0 vote283 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote264 views1 answer
Sql show all users
SQL
0 vote294 views1 answer
Suhaib
SQL
-2 votes257 views1 answer
Mysql not empty
SQL
0 vote278 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote283 views1 answer
Get initials name in sql
SQL
3 votes269 views2 answers
Sql asc
SQL
0 vote256 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
1 vote267 views1 answer
Increasing font and zooming in mysql workbench
SQL
45 votes332 views5 answers
Grant all privileges mysql
SQL