how to get quantity to the next increment of 10? 2

[ndp]

Hi,
In my stored procedure, I am getting quantity field which I want to round up to the next increment of ten. If I use ceiling function it increments only to next numeric. For example, If the quantity is 23.3, then I would want it as 30 and if the quantity is 4, I would want it 10.
There might be a simple way to do it, but somehow, I can not think of anything.
Can somebody suggest a way to do it?

Thanks in advance,
ndp

 

[donutman]

You can do it by dividing the result by 10, then use the ceiling function and finally multiply that by 10.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[ndp]

Thanks a lot! That works great! I will give you a star!!
ndp

 

[mrdenny]

Karl we do think alike. I was going to recommend the exact same thing.

Denny

--Anything is possible. All it takes is a little research. (Me)