On Mon, Jun 16, 2003 at 05:02:34PM -0500, Bu, Ning wrote:
I have a field set up as money and I try to calculate some number
and put in this field, but the number will be 6 demical point and I
want to cut it to only 2-4 decimal point, how can I do it? Thanks
round(); eg
select round(foo, 2)
--- Rodger Donaldson [EMAIL PROTECTED] wrote:
On Mon, Jun 16, 2003 at 05:02:34PM -0500, Bu, Ning
wrote:
I have a field set up as money and I try to
calculate some number
and put in this field, but the number will be 6
demical point and I
want to cut it to only 2-4 decimal point, how