/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 vote186 views1 answer
Update top 100 sql
SQL
0 vote184 views1 answer
Database xml sql
SQL
0 vote184 views1 answer
Postgres add prefix to primary key
SQL
3 votes200 views1 answer
Select sequence oracle
SQL
5 votes273 views1 answer
Mysql last day of next month
SQL
16 votes215 views1 answer
Sql comment'
SQL
3 votes239 views2 answers
@sqlresultsetmapping
SQL
2 votes224 views2 answers
Python escape string for sql
SQL
1 vote204 views1 answer
How to use db.execute
SQL
3 votes194 views1 answer
Show index table
SQL