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