SELECT TRIM( TRAILING '.' FROM TRIM( TRAILING '0' FROM mycol ) ) Ignatius _________________________ ----- Original Message ----- From: "Shaun" <shaun@mania.plus.com> To: <php-db@lists.php.net> Sent: Friday, October 03, 2003 5:12 PM 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
