Hi Alan,
Just add .0049
Select ROUND(2128.0748 + .0049, 2)
>Hi,
>
>I need to do some rounding to 2 decimal places - but I need to round up and I'm not sure how to get the results I'm looking for.
>
>For example:
>
>
>Select ROUND(2128.0748, 2)
>
>returns 2128.07
>
>
>
>I want it to return 2128.08 - any ideas on how to go about achieving this result?
--sb--