If the ceil function won't do it you can truncate it and add 1.
Ty...
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 2:12 PM
To: Fabio Bernardo; Mysql (E-mail)
Subject: RE: Round Question
what I've done is
select ceil(value)
Hi,
I tried:
Select ceiling(1.2)
It worked and returned "2".
HTH
Allen
> -Original Message-
> From: Dan Greene [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 05, 2003 12:12 PM
> To: Fabio Bernardo; Mysql (E-mail)
> Subject: RE: Round Question
>
what I've done is
select ceil(value)
(not sure if ceil is the function on MySQL, but there is a ceiling function, I'm
sure...)
> -Original Message-
> From: Fabio Bernardo [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 05, 2003 2:59 PM
> To: Mysql (E-mail)
> Subject: Round Question