• Something like this should mix up your numbers ... you may have to run it a couple of times to verify that you get all records.

    WITH startingList

    AS (SELECT

    ROW_NUMBER() OVER (ORDER BY NEWID()) AS rn

    ,PKfield -- this is the unigue identifier for the records, its PK if you have one

    ,phoneNumber

    FROM yourTable) -- your table's name

    ,jumbledList

    AS (SELECT

    ROW_NUMBER() OVER (ORDER BY NEWID()) AS rn

    ,phoneNumber AS newnumber

    FROM yourTable) -- your table's name

    UPDATE a

    SET a.phoneNumber = c.newNumber

    FROM

    yourTable AS a

    INNER JOIN startingList AS b

    ON a.PKfield = b.PKfield

    INNER JOIN jumbledList AS c

    ON b.rn = c.rn

    WHERE

    a.phoneNumber <> c.newNumber

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg