/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

2 votes316 views1 answer
Add 2 hours to current time in MySQL
SQL
7 votes329 views6 answers
Group_concat in mysql
SQL
0 vote315 views1 answer
Postgres truncate with cascade
SQL
0 vote371 views1 answer
Drop a view in sqlite
SQL
0 vote353 views2 answers
Select last 30 days sql
SQL
0 vote356 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
5 votes316 views2 answers
Update all rows mysql
SQL
3 votes331 views2 answers
Sql end of month
SQL
8 votes341 views2 answers
Mysql get first x characters
SQL
2 votes345 views1 answer
Revokeprivileges mysql
SQL