/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 vote352 views1 answer
Apex for oracle 11g
SQL
0 vote378 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
6 votes334 views1 answer
Phpmyadmin password root
SQL
0 vote345 views2 answers
Call to undefined function mysql_query()
SQL
11 votes387 views1 answer
Oracle insert from select
SQL
0 vote417 views1 answer
Trigger
SQL
0 vote325 views1 answer
Mysql check datetime equals date
SQL
1 vote328 views3 answers
Postgresql crete view
SQL
0 vote342 views1 answer
Mariadb current date plus 1 day
SQL
44 votes384 views6 answers
Rename command in sql
SQL