/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 vote310 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote318 views2 answers
Mysql on update current_timestamp
SQL
0 vote313 views1 answer
Load data from text file to mysql database on mac terminal
SQL
2 votes305 views1 answer
Mysql how to store lat,lng
SQL
1 vote309 views1 answer
Float precision in psql
SQL
0 vote303 views1 answer
How to check xampp mysql password
SQL
0 vote332 views1 answer
Sql query wordpress export post
SQL
1 vote316 views1 answer
Sql server epoch to datetime
SQL
0 vote300 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote296 views1 answer
Postgres truncate with cascade
SQL