/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 vote150 views1 answer
Mysql create table like
SQL
0 vote158 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
4 votes152 views3 answers
How to describe a table in sqlite3
SQL
0 vote172 views1 answer
Pl sql search in all packages
SQL
0 vote157 views1 answer
Intellij idea add mysql connector
SQL
1 vote150 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote161 views1 answer
How to install Firebird
SQL
0 vote143 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote165 views1 answer
Mysql get nth highest
SQL
3 votes157 views1 answer
Select table column in sql
SQL