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) (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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
