/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

24 votes222 views4 answers
Mssql get all table names
SQL
12 votes228 views10 answers
Google
SQL
0 vote213 views1 answer
Sql right characters
SQL
14 votes236 views2 answers
Oracle add attribute to table
SQL
9 votes247 views6 answers
Check constraint in sql
SQL
0 vote217 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote228 views1 answer
User defined variables in sql
SQL
0 vote362 views1 answer
Sql change a colum to unique
SQL
0 vote177 views1 answer
Check if has alpha characters sql
SQL
11 votes233 views1 answer
Oracle view ddl
SQL