• David,

    Thanks very much.

    DECLARE @Col2 decimal,@Col3 int,@Col4 int

    SELECT @Col2 = [Col 2],@Col3 = [Col 3],@Col4 = [Col 4]

    FROM

    WHERE [Col 1] = 10000

    UPDATE

    SET [Col 2] = @Col2,

    [Col 3] = @Col3,

    [Col 4] = @Col4

    WHERE [Col 1] > 10000

    Did exactly what was required.