/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

11 votes205 views1 answer
Oracle insert into where
SQL
0 vote196 views1 answer
View to table sql
SQL
0 vote205 views1 answer
Vbscript connect mssql
SQL
5 votes217 views6 answers
In operator sql
SQL
1 vote197 views1 answer
How to see logical reads in sql server
SQL
0 vote223 views1 answer
Show specific events on mysql
SQL
0 vote192 views1 answer
How to find database collation in postgres
SQL
0 vote218 views1 answer
"Hello User Name"
SQL
0 vote196 views1 answer
Equi joins in oracle
SQL
1 vote204 views2 answers
Backup table mssql
SQL