>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?
You can also use:
Select CEILING(2128.0748*100)/100
BOb