/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

1 vote212 views1 answer
Add multiple row table pl sql
SQL
0 vote221 views1 answer
Sql query use select name inside where clause
SQL
1 vote196 views1 answer
Oracle apex prevent initial load
SQL
0 vote219 views1 answer
Separator mysql
SQL
0 vote199 views1 answer
Java sql connection
SQL
2 votes257 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote184 views1 answer
Sql random decimal
SQL
0 vote287 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote277 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote193 views1 answer
How to set sql_mode for a query in CI model
SQL