/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

4 votes214 views2 answers
Oracle sql group by date year
SQL
0 vote154 views1 answer
Ms sql print more than 1 variable
SQL
0 vote319 views1 answer
SQL query to verify the size of the table
SQL
1 vote225 views1 answer
Drop colum oracle 18c
SQL
0 vote228 views1 answer
How to check foreign key constraint in sql
SQL
1 vote198 views1 answer
Get rows affected mysql python
SQL
1 vote201 views1 answer
Select if then postgresql
SQL
0 vote205 views1 answer
Java check if something is in mysql table
SQL
0 vote396 views1 answer
Get first match in each group mysql query
SQL
13 votes191 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL