<code>
USE [BRAZIL]
DECLARE @PRODUCTDESCRIPTION nvarchar(max);
DECLARE @MERDA nvarchar(max);
DECLARE @CONTADOR Int;
DECLARE C CURSOR READ_ONLY FOR SELECT distinct Id FROM ProductVariant
OPEN C
FETCH NEXT FROM C INTO @CONTADOR
WHILE (@@FETCH_STATUS = 0)
    BEGIN
    SET @PRODUCTDESCRIPTION = (SELECT Description FROM ProductVariant WHERE ID = @CONTADOR );
    IF CHARINDEX('This Should be Removed', @PRODUCTDESCRIPTION) > 0
        BEGIN
        SET @MER = (SELECT SUBSTRING(@PRODUCTDESCRIPTION, 0, CHARINDEX('This Should be Removed', @PRODUCTDESCRIPTION)));
        UPDATE ProductVariant
        SET Description = @MER
        END
    set @PRODUCTDESCRIPTION = '';
    FETCH NEXT FROM C INTO @CONTADOR
END
CLOSE C
DEALLOCATE C
</code>