How to split a Name using sql in Big sql environment?

Question

I have a string like "Telugu,Praveen Kumar". I need to split this string like First_Name = Praveen, Last_Name= Telugu, Middle_Name= Kumar. Kindly help me out!!!

Answer 1

Tryn this one:

UPDATE table
SET  FirstName  = SUBSTRING(FullName, CHARINDEX(',', FullName)+1, CHARINDEX(' ',FullName)-CHARINDEX(',', FullName)-1)
    ,MiddleName = SUBSTRING(FullName, 0, CHARINDEX(',', FullName))
    ,LastName   = SUBSTRING(FullName, CHARINDEX(' ', FullName)+1, LEN(FullName)-CHARINDEX(' ', FullName)+1)