/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 votes152 views3 answers
Current month mysql query
SQL
1 vote150 views3 answers
Mysql connection string
SQL
0 vote213 views1 answer
Postgres rename database
SQL
0 vote150 views1 answer
Sql pivot without aggregate
SQL
0 vote145 views1 answer
Oracle create job if not exists
SQL
0 vote156 views1 answer
Setval postgres example table id
SQL
0 vote144 views1 answer
Parsing float to int in mysql
SQL
0 vote176 views1 answer
Reset postgres table index to next max value
SQL
0 vote149 views1 answer
Left join in codeigniter query builder
SQL
0 vote145 views1 answer
2020 new year
SQL