/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

2 votes310 views1 answer
Postgresql create table as select
SQL
2 votes280 views2 answers
Mysql on duplicate key ignore
SQL
0 vote307 views2 answers
Replace null with 0 in sql
SQL
0 vote290 views1 answer
Mysql to get column name in database
SQL
1 vote267 views1 answer
Sql select table header
SQL
1 vote322 views1 answer
Postgres see sequence current state
SQL
5 votes311 views2 answers
Mysqldump password
SQL
3 votes304 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote302 views1 answer
Mysql row generator
SQL
1 vote293 views2 answers
Postgresql remote connect
SQL