/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 vote148 views1 answer
Oracle duration between timestamps
SQL
0 vote217 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote153 views1 answer
Mysql check datetime equals date
SQL
2 votes179 views1 answer
Sql server: select column values as comma separated string
SQL
-1 vote167 views3 answers
PS5
SQL
5 votes198 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote178 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote174 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
1 vote144 views3 answers
How to get date in sql
SQL
1 vote199 views1 answer
Sqlite show columns in table
SQL