/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

0 vote161 views1 answer
Backup a table in sql
SQL
0 vote187 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
2 votes179 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote173 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
1 vote172 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote177 views1 answer
Error code 1241 mysql
SQL
0 vote189 views1 answer
Sql to excel pgadmin
SQL
0 vote175 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote188 views1 answer
Change role postgres
SQL
0 vote169 views1 answer
Sql convert float to string
SQL