/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 votes123 views2 answers
Mysql get year from date
SQL
7 votes116 views2 answers
Show size database mysql
SQL
2 votes137 views3 answers
Row number mysql
SQL
1 vote116 views1 answer
Ilike for date postgres
SQL
7 votes154 views1 answer
Show line number in sql server
SQL
1 vote107 views3 answers
Remove unique key from a table
SQL
0 vote153 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote116 views1 answer
Oracle DROP PROGRAM
SQL
6 votes126 views2 answers
How to copy data in sql
SQL
1 vote114 views2 answers
Populate sql table with random data
SQL