Re: simple SQL question about dividing numbers

Hi.

Sure he should lookup the Round() function, but only to know, that in his matter, it wouldn´t be the right one to choose.

Just try Round(19/5), and you won´t get 3, and that is, what he wanted.

Alex

Sunil <sunil_franklin_at_hotmail.com> schrieb in im Newsbeitrag: Vfjc8.26$G4.443_at_inet-nntp1.oracle.com...
> lookup the Round() function.
>
>
> "Julian Kooiker" <julian.kooiker_at_quicknet.nl> wrote in
message
> news:wufc8.80951$yS6.6725884_at_amsnews02.chello.com...
> > Hi,
> >
> > I have a little problem and I can't find it in the
documentation of sql.
> (I
> > have a small learning book).
> > If I divide a number, for example 16 / 5 then I want to
grab only the
> number
> > before the comma. Which function do I need to use?
> >
> > Julian Kooiker
> >
> >
>
>
Received on Thu Feb 21 2002 - 08:00:19 CST