decimals to INT

[iainrkemp14]

Hi all,

I have atable full of data, a lot of which is decimals (ie, 1.423). Does anyone know a solution for changing all this data to whole numbers - perhaps an update query or something? Ideally I would like to round everything to the nearest whole number.

Cheers,

- Iain

 

[mikevh]

UPDATE YourTable
SET f1 = ROUND(fi), f2 = ROUND(f2), f3 = ROUND(f3);

where YourTable is the name of your table and
f1, f2, f3 are names of fields you want to round.

I suggest you back up your table before you do this.