/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

0 vote123 views1 answer
Sql convert datetime to year
SQL
2 votes77 views1 answer
Sql select in list
SQL
1 vote121 views1 answer
Postgres grant read only access to database
SQL
2 votes130 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote148 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote173 views1 answer
Mysql show schema
SQL
0 vote130 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote160 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote130 views1 answer
How to check xampp mysql password
SQL
1 vote114 views1 answer
Index a database column sql
SQL