/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 vote142 views2 answers
Create sequence if not exists postgres
SQL
0 vote141 views1 answer
Sql trying to delete database in use
SQL
-1 vote140 views1 answer
Ssql to lowercqse
SQL
3 votes215 views3 answers
Mysql get table size
SQL
1 vote152 views1 answer
Print all records of table in mysql
SQL
2 votes146 views1 answer
Mysql Incorrect column specifier for column
SQL
3 votes187 views3 answers
List columns in table postgres
SQL
0 vote138 views1 answer
Min mysql
SQL
16 votes148 views3 answers
Tsql rename column name
SQL
0 vote95 views1 answer
Oracle list all stored procedures
SQL