I just realized that this does not work with integers such as 80, so one should add a test condition:
SELECT IF( ROUND( mycol ) = mycol, mycol, TRIM( TRAILING '.' FROM TRIM( TRAILING '0' FROM mycol ) ) ) Ignatius _________________________ ----- Original Message ----- From: "Ignatius Reilly" <[EMAIL PROTECTED]> To: "DB list PHP" <[EMAIL PROTECTED]>; "Shaun" <[EMAIL PROTECTED]> Sent: Friday, October 03, 2003 5:27 PM Subject: Re: [PHP-DB] Round a number > SELECT > TRIM( TRAILING > '.' > FROM TRIM( TRAILING '0' FROM mycol ) > ) > > > Ignatius > _________________________ > ----- Original Message ----- > From: "Shaun" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, October 03, 2003 5:12 PM > 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 > > > > > > -- > 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