Re: [SQL] set decimal point in SQL

2003-06-18 Thread Rodger Donaldson
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)

Re: [SQL] set decimal point in SQL

2003-06-18 Thread Jeff Eckermann
--- 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