/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 vote123 views1 answer
Sql select lowest value row
SQL
0 vote134 views1 answer
Vbscript connect mssql
SQL
1 vote132 views1 answer
Adding a default constraint to an existing column in sql
SQL
28 votes130 views4 answers
Show tables mysql
SQL
0 vote132 views1 answer
Oracle last connection
SQL
0 vote131 views1 answer
Postegresql update to null
SQL
0 vote138 views1 answer
List in one column mysql
SQL
0 vote126 views1 answer
Check connections to database postgres
SQL
0 vote137 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote186 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL