hi

im trying to update one of the records in my table 'City' called 'Population' by 5%.

UPDATE City
SET
Population= Population * 1.05;

The calculation seems correct but its just the final result which seems to not have proper rounding.

for example
one of the records in 'Population' is 1.659.000
after i use the update function my final answer comes out to 1.74195...