Split string column into multiple rows

 SELECT A.content_id,
     Split.a.value('.', 'VARCHAR(100)') AS String
 FROM  (SELECT content_id,
         CAST ('' + REPLACE(page_path, '
', '') + '' AS XML) AS String
     FROM  ContentTrackerMaster where content_id = 518) AS A CROSS APPLY String.nodes ('/M') AS Split(a);