Re: set decimal point in SQL

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		rodgerd@diaspora.gen.nz
I don't mind straight people, as long as they act gay in public