/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 vote64 views1 answer
Oracle db list usernames
SQL
0 vote110 views1 answer
Vbscript clean up ADODB.Recordset
SQL
1 vote95 views1 answer
Index a database column sql
SQL
0 vote118 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote103 views1 answer
Sql get date from timestamp
SQL
0 vote100 views1 answer
Add plugins to mysql workbench
SQL
1 vote114 views1 answer
SQL: merging multiple row data in string
SQL
0 vote100 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote101 views1 answer
Mysql workbench indent formatting
SQL
8 votes98 views3 answers
Postgresql connection string c#
SQL