/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

7 votes264 views2 answers
Show size database mysql
SQL
0 vote253 views1 answer
Mysql disable query caching
SQL
0 vote264 views1 answer
Oracle sql log to console
SQL
4 votes256 views1 answer
Add constraint fk
SQL
0 vote260 views1 answer
Sql server isnull function nor working count
SQL
0 vote264 views1 answer
What is between keyword used for
SQL
4 votes252 views4 answers
Date less than in sql
SQL
1 vote270 views1 answer
Postgresql not in
SQL
1 vote273 views1 answer
Postgres left join
SQL
6 votes260 views4 answers
Mysql group by month
SQL