/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 vote251 views1 answer
How to print longest name in sql
SQL
0 vote289 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote250 views1 answer
How to see the query of a view in mysql
SQL
0 vote275 views1 answer
Sqlalchemy get schema from database
SQL
0 vote272 views1 answer
Mysql 8 error on identified by
SQL
0 vote272 views1 answer
Select amount weeks between two dates mysql
SQL
0 vote325 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote287 views1 answer
Doesn't have default value mysql
SQL
1 vote297 views1 answer
Primary key with prefix sql
SQL
1 vote288 views2 answers
Snowflake alter column data type
SQL