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 > > > I write this command: > > Select round(1.1) > and obtain 1 as answer > Is there a round command to obtain 2 as answer. I mean, in Excel this > command is knwon as RoundUp! > > thanks a lot > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]