to my knowledge the ROUND function should work the same:
SELECT ROUND(MYFIELD,2) FROM MY TABLE</pre>
Don’t forget to visit my blog: <a href=”http://itknowledgeexchange.techtarget.com/it-support/”>If it has a plug, it’s IT stuff!!</a>
Rounding (or truncation) is specified in Query/400 in the <b>Specify processing options</b> selection at the bottom of <b>Define the Query</b>. The choices for ‘Use rounding’ are <i>Blank, Y=Yes, N=No</i>.
By leaving the option blank, you tell Query/400 to make the choice during calculations although the choice is simply determined by running in the S/36 environment (becomes N) or OS/400 (becomes Y). Specifying either Y or N opens the risk of accumulated errors during complex calculations. You should understand how your choice will affect results before setting Y or N.