/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 vote336 views1 answer
Oracle current timestamp
SQL
8 votes362 views2 answers
Update sql server from another table
SQL
2 votes321 views1 answer
Oracle index size calculation
SQL
0 vote307 views1 answer
Postgresql copy backup table
SQL
2 votes285 views1 answer
Mysql admin u root p password change password
SQL
0 vote350 views1 answer
How to generate ids in sql
SQL
2 votes333 views2 answers
Sql first character
SQL
0 vote321 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote340 views1 answer
Alter column to not null with default value sql server
SQL
2 votes355 views1 answer
Merge firstname and lastname in sql oracle
SQL