[Sourcecode]

Select Round( 1.74, 0 ) -> returns 2.00

Select Round (1.74, 2) -> returns 1.74

Select Round (1.744, 2 ) -> returns 1.74

Select Round( 1.749, 2 ) -> returns 1.75

select round (1.749, 2,1) -> returns 1.740

select round (1.749, 2, 0 ) -> returns 1.750

[/Sourcecode]

Advertisements