Hi Dan, Your suggestion works but it slows down things a lot. Thats just a workaround, my quick tests showed it takes about 30% longer for the query to complete...
It seems to be a bug in mysql, but the problem is that my whole thing is running fine on a bigger production system and I'd not like to update mysql when it's not really necessary... it does about 60 queries/second and is pretty important for my client's business... i dont like experiments... maybe someone of mysqlab could comment the problem in a few words? is there are workaround with better performance? thanks Richard > Perhaps this is something like what your looking for? > > select > substring(round(number,digits) ,1,instr(round(number,digits),'.')+digits) > as > roundednumber,digits,number > >from testme > > Regards, > Dan > > > > > > mysql> select round(number,digits) from testme; > > > +----------------------+ > > > | round(number,digits) | > > > +----------------------+ > > > | 100.4240 | > > > | 85.4000 | > > > +----------------------+ > > > 2 rows in set (0.08 sec) -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php