Round a number
| From: | Shaun | Date: | Fri, 03 Oct 2003 15:12:17 +0000 |
| Subject: | Round a number | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30821@lists.php.net to get a copy of this message | ||
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