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) from bar ...will give you values in column foo rounded to 2 decimal places. -- Rodger Donaldson [EMAIL PROTECTED] I don't mind straight people, as long as they act gay in public ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
