While Loop

Hello everyone,

I've got this While loop here which is giving me a problem:

WHILE (SELECT ProductId FROM _ShoppingCart WHERE CartId = @CartId) IS NOT NULL
BEGIN

            DECLARE @ProdId int, @ProdSize varchar, @ProdQuan int

            SELECT @ProdId = ProductId, @ProdSize = ProductSize, @ProdQuan = Quantity FROM _ShoppingCart WHERE CartId = @CartId
                      
            If @ProdSize = 'XL'
            BEGIN
                UPDATE
                    _ProductBatches
                SET
                    XL = '0'
                WHERE
                    ProductId = @ProdId
            END

            DELETE FROM _ShoppingCart WHERE ProductId = @ProdId AND CartId = @CartId

END

 

The problem is that the IF statement isn't being executed. And I know for a fact that 'XL' is ProductSize in my _ShoppingCart database. Whats even stranger is that my delete statement is being executed. So @ProdId is Being set correctly, but when it gets to the IF @ProdSize = 'XL' it doesn't get executed for some reason. If @ProdId is being recognized correctly in my DELETE statement, why is my @ProdSize not being reconized correctly in my IF statement. I checked my _ShoppingCart database, and my ProductSize is definitely 'XL'. Can any one see what could be going on here.

 

Thank you,

 

Alec