/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 votes197 views1 answer
Oracle trace file
SQL
0 vote173 views1 answer
Sql query to delete row by id
SQL
17 votes183 views6 answers
Change column name in sql
SQL
31 votes178 views3 answers
SQL Server change column data type
SQL
0 vote719 views1 answer
Sql show table name in result
SQL
0 vote204 views1 answer
Implode in sql query
SQL
2 votes184 views1 answer
Guid to string sql
SQL
2 votes126 views2 answers
Mysql get last character of string
SQL
9 votes190 views6 answers
Check constraint in sql
SQL
0 vote187 views1 answer
Sql last 3 rows
SQL