Thread: Removing word from product

Hi

I've ran this code that adds a "Buy One Get One Free" after each product for a supplier but does anyone know how to remove the words?

update Product set Name = Name + ' (Buy One Get One Free)',
SKU = SKU + 'Z'
where ProductID in (select ProductID from ProductManufacturer
where ManufacturerID = 28)

Well, you can try this script:

Code:

DECLARE @len int
SET @len = LEN('(Buy One Get One Free)')
SELECT @len
UPDATE p SET p.[Name] = Name + SUBSTRING(Name, (@len+1), len(p.Name) - @len)
FROM Product p
WHERE p.Name like '%(Buy One Get One Free)'

Please ensure a full-backup of your database prior to any change for safety...