Try the rtrim function in php
Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 "Pay It Forward" mailto:[EMAIL PROTECTED] http://accessingram.com > -----Original Message----- > From: Shaun [mailto:[EMAIL PROTECTED] > Sent: Friday, October 03, 2003 10:12 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] 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 >