• Hello,

    Yes, "GilaMonster" is right. It is the zero filled values that cause the problem.

    There is the question of what you want to do in the case of zeros? Do zeros represent a non existent value for the row? In this case you might want the new column to contain a Null.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group