/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 vote210 views1 answer
Test sql query
SQL
-1 vote235 views1 answer
Mysql faster insert
SQL
0 vote204 views1 answer
Sql column as header
SQL
3 votes198 views1 answer
Sql multiple column index
SQL
0 vote214 views1 answer
Hex string sql becomes int64
SQL
0 vote186 views1 answer
What are the aggregate function in sql
SQL
0 vote192 views1 answer
How much table store postgres
SQL
6 votes189 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
12 votes208 views3 answers
Install sqlite driver ubuntu
SQL
4 votes201 views1 answer
T-sql get duplicate rows
SQL