* Doug Thompson > Roger: > I found using variables to work as expected with 3.23.43 and Win98. > > I was unable to duplicate your changing outputs.
I was using a 3.23.30-gamma win2k. > mysql> select @a:=digits,number,round(number,@a) from testme; > +------------+----------+------------------+ > | @a:=digits | number | round(number,@a) | > +------------+----------+------------------+ > | 3 | 100.4235 | 100.4230 | > | 1 | 85.4000 | 85.4000 | > +------------+----------+------------------+ > 2 rows in set (0.00 sec) Wouldn't you expect the output to be something like: +------------+----------+------------------+ | @a:=digits | number | round(number,@a) | +------------+----------+------------------+ | 3 | 100.4235 | 100.423 | | 1 | 85.4000 | 85.4 | +------------+----------+------------------+ also.... 100.423... should it not be 100.424? This is still my win2k 3.23.30-gamma: mysql> select round(100.4234,3),round(100.4235,3),round(100.42350001,3); +-------------------+-------------------+-----------------------+ | round(100.4234,3) | round(100.4235,3) | round(100.42350001,3) | +-------------------+-------------------+-----------------------+ | 100.423 | 100.423 | 100.424 | +-------------------+-------------------+-----------------------+ 1 row in set (0.00 sec) The same statement on solaris 3.23.39-log: mysql> select round(100.4234,3),round(100.4235,3),round(100.42350001,3); +-------------------+-------------------+-----------------------+ | round(100.4234,3) | round(100.4235,3) | round(100.42350001,3) | +-------------------+-------------------+-----------------------+ | 100.423 | 100.424 | 100.424 | +-------------------+-------------------+-----------------------+ 1 row in set (0.05 sec) -- Roger query --------------------------------------------------------------------- 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