Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hugo Kornelis Round up or down I RE: Round up or down I

  • August 3, 2010 at 3:33 am

    #1201410

    even this works...

    set @result = round(cast(5 as float) / 3,1)

    i guess either the numerator or denominator should be in the proper format.

    cengland0 (8/3/2010)

    So you need to cast it like this?

    round(cast(5 as float) / cast(3 as float),1)