Break Comma Separated values into multiple columns
DECLARE @Tmp TABLE (Id INT,Name VARCHAR(20)) INSERT @Tmp SELECT 1,'Muhammad,K,Jawad' INSERT @Tmp SELECT 2,'Ali,S,Arif' INSERT @Tmp SELECT 3,'Kamran,C,Shahid' --Using PARSENAME SELECT Id, PARSENAME(REPLACE(Name,',','.'),3) FirstName, PARSENAME(REPLACE(Name,',','.'),2) MiddleName, PARSENAME(REPLACE(Name,',','.'),1) LastName FROM @Tmp