>I have a rounding problem...
>
>sgft_val = 2932.0047
>Round(sgft_val, 2) produces 2932.00.
>I need it to round up and = 2932.01.
>
>Any suggestions?
Don't use ROUND() alone if you don't want the standard ROUND() behavior; the algorithm rounds up where the next lower fractional portion is .5 or greater; IOW 2932.0047 rounded to 2 decimals will yield 2932.00, while 2932.0051 rounded to 2 decimal places will yield 2932.01
If you -always- want to round up for 2 decimal places, try the following instead:
ROUND(CEIL(nNumberToRoundUp * 100) / 100, 2)
The ROUND() is present only to trim the trailing decimal places; it can be omitted.