/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 vote362 views1 answer
Mysql tables max count
SQL
2 votes336 views1 answer
Sqlite show table indexes
SQL
0 vote386 views1 answer
Sql pivot table
SQL
0 vote345 views1 answer
Mysql workbench not showing schemas
SQL
0 vote373 views1 answer
Sql script get all stored procedures from database
SQL
0 vote354 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
1 vote449 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote330 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote453 views1 answer
Trigger
SQL
0 vote390 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL