hi all,
i need help to round value as ex.. 0.823 to 0.8 or 68.987 to 69.0 or 56.92 to 75.0
i try round(value,1) it work for 68.987 but for 56.92 round(valuw,0)
i use this code
update newtest set tper=(((ty2010-ty2009)/ty2009)*100/100)*100 where.........