/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

3 votes347 views2 answers
How to modify rows in SQL Server
SQL
0 vote324 views1 answer
Mysql workbench search all tables
SQL
1 vote344 views1 answer
Sqlite create index
SQL
23 votes384 views6 answers
Create table sql server
SQL
0 vote337 views1 answer
How to query all tables mysql at the same time
SQL
0 vote302 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote349 views1 answer
Mysql update table from select on another table
SQL
2 votes343 views1 answer
Add default sql server
SQL
0 vote383 views1 answer
Add super privilege mysql
SQL
0 vote362 views1 answer
Dump only data
SQL