SQL HOW TO GET FIRST , MIDDLE AND LAST NAME USING CHARINDEX in sql server

Question

what to split first middle and last name in sql server i have name like Tom dike Harry

Answer 1

@Manoj Kumar, first, why not use separate fields for first, middle, and last name? it would be easier to manage and search for individual field. Also what's with the ALL CAPS in the question title?.

You might consider to use STRING_SPLIT function, but from the documentation I see that it's not all backward compatible. Following is the link to the documentation:

https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql