You can use string manipulation, but it may be easier and simpler to use XML features that SQL Server offers. To select the data that you described run this query:SELECT a.sku, b.BulletsFROM (SELECT DISTINCT sku FROM Product) a OUTER APPLY ( SELECT bullet_point AS [li] FROM Product b WHERE b.sku = a.sku FOR XML PATH('ul') ) b(Bullets)
If that looks like what you want, then you can use that as a subquery to do the update, as shown below:UPDATE p SET Bullets = s.Bullets FROM ( SELECT a.sku, b.Bullets FROM (SELECT DISTINCT sku FROM Product) a OUTER APPLY ( SELECT bullet_point AS [li] FROM Product b WHERE b.sku = a.sku FOR XML PATH('ul') ) b(Bullets)) s INNER JOIN Product p ON p.sku = s.sku;