Using the command with version heres the outputs
SELECT VERSION( ) , (( 200.45 *1 ) * ( 10 /100 )), ROUND( ( 200.45 *1 *
( 10 /100 ) ) , 2 ) , ROUND( 20.045, 2 ) ;

Windows 2003
5.0.22-community-nt 20.045000 20.05 20.05

Windows 2003
4.1.18-nt-max 20.05 20.05 20.05

Centos
4.1.21-standard 20.04 20.04 20.05

FreeBSD
3.23.58 20.05 20.05 20.05

After all my testing i've found that the only system that does the
Round and the math good is windows.


On Dec 22, 6:03 pm, Brian Wakem <n...@email.com> wrote:
> Lee Peedin wrote:
> > On 21 Dec 2006 07:03:22 -0800, "kkmi...@gmail.com" <kkmi...@gmail.com>
> > wrote:
>
> >>Can some one plz explain this???
>
> >>SELECT ((200.45 * 1) * (10/100)),ROUND( (200.45 * 1 * (10/100)) ,2);
>
> >>Linux (Servidor Mysql 4)
>
> >>20.04 | 20.04
>
> >> Windows (Servidor Mysql 4)
>
> >>20.05 | 20.05
>
> >>Thanks
>
> > Here's my results of:
> > SELECT VERSION();
> > SELECT ((200.45 * 1) * (10/100)),ROUND( (200.45 * 1 * (10/100)) ,2)
>
> > Linux
> > 5.0.24a
> > 20.45000 | 20.05
>
> > Windows
> > 5.0.24-community-nt
> > 20.45000 | 20.05Linux 4.1.16
> 20.04 | 20.04
>
> Linux 5.0.24-standard-log
> 20.045000 | 20.05
>
> --
> Brian Wakem
> Email:http://homepage.ntlworld.com/b.wakem/myemail.png