Add % to a INT field

matrix_ · October 4, 2010, 1:23am

Hi,

How can I add 5% to a column thats hold INT data?

Thanks

matrix_ · October 4, 2010, 1:32am

Oh… to easy… so to make it 5.5% it would be 1.055

?

Thanks

r937 · October 4, 2010, 1:26am

UPDATE daTable
   SET daColumn = daColumn * 1.05