Re: simple SQL question about dividing numbers

hi,

Julian Kooiker wrote:
>
> 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

Have a look at TRUNC().

ciao
andreas Received on Fri Feb 22 2002 - 09:32:33 CST