Try the rtrim function in php Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 "Pay It Forward" mailto:gary.every@ingramentertainment.com http://accessingram.com > -----Original Message----- > From: Shaun [mailto:shaun@mania.plus.com] > Sent: Friday, October 03, 2003 10:12 AM > To: php-db@lists.php.net > Subject: Round a number > > > Hi, > > I have a query that returns a number from culculation in my table. It > returns say 4.00, 8.75, 0.00, 12.50 etc. How can I get MySQL > to return the > number without any zeros, i.e. 4, 8.75, 0, 12.5 etc? > > Thanks for your help > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >
