fetch second word from a string in ms sql

Solutions on MaxInterview for fetch second word from a string in ms sql by the best coders in the world

Search
showing results for - "fetch second word from a string in ms sql"
Teddy
26 Nov 2019
1-- Example there is a column FULL_NAME which contains two words like "Bob Dylan"
2-- To fetch second word "Dylan" we will use space as a divisor 
3-- and take 10 signs after space
4SELECT SUBSTRING(FULL_NAME, (SELECT CHARINDEX(' ', FULL_NAME)+1), 10) 
5FROM TABLE_NAME;
similar questions
sql server 2016 split stringsql searching via key wordsearch text in all sql server stored proceduretsql get beginning of yearhow to fetch first 5 characters in sqlfetcht he leftmost word in a comma separated string in sqlfetch first 5 rows in oracle sql developerfetch first 10 rows in oracle sql developersql server rtrim everything after charactersql print all names that start with a given letterreading from right to left from string find first special characters in sqlget first 3 letters in sqlget who is hired in specific month in sqlfind most frequent word in sql serverquery only first letter stringget first 3 letters name in sqlget first monday of month sqlquery string starts with vowelst sql return on letters onlystarts and end with vowel sqlwrite sql query to show the details start from digitget first 2 letter in sqlsql server select value large text
queries leading to this page
fetch second word from a string in ms sqlfetch second word from a string in ms sql