parse a name with commas sql server
Posted on 2011-02-26
I have looked at the other examples in EE but am still stumped with parsing the following:
I need to parse this out into last_name, first_name, middle
I can get the last name with a charindex -1 from the comma.
I'm having (mental) problems with the substring for the first name and then with dealing with the comma and name suffix at the end (e.g. JR or III).
your sql help is greatly appreciated!