/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

15 votes131 views2 answers
How to know the username of postgresql
SQL
0 vote122 views1 answer
Postgres where
SQL
5 votes76 views1 answer
Postgres upsert
SQL
2 votes129 views1 answer
Sql server check for value in multiple columns
SQL
0 vote143 views1 answer
Sql delete caracter list
SQL
0 vote175 views1 answer
Sql int vs integer
SQL
0 vote121 views1 answer
Add multiple field in table sql
SQL
0 vote120 views1 answer
Mysql workbench view
SQL
1 vote114 views1 answer
Mysql get character set
SQL
0 vote115 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL