If format is consistent. do like thisSELECT RTRIM(LTRIM(REPLACE(LEFT(Field,PATINDEX('%SkillSet :%',Field)-1),'Name:',''))) AS Name,STUFF(LEFT(Field,PATINDEX('%Question Type:%',Field)-1),1,PATINDEX('%SkillSet :%',Field)+10,'') AS Skillset,STUFF(LEFT(Field,PATINDEX('%Link :%',Field)-1),1,PATINDEX('%Question Type:%',Field)+14,'') AS QuestionType,STUFF(Field,1,PATINDEX('%Link :%',Field)+6,'') AS LinkFROM table
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs