>>Just when you think you have it all figured out, you can always count on Cristof to burst your bubble.
>>
>Naw, Christof didn't burst my bubble. Look at the title "Rounding down". FLOOR() rounds -2.5 down to -3. If it returned -2 it'd be rounding up.:-)
George,
Yep.. Zero is always down. <g>
Kind of like the center of the Earth. From the 'bottom' the center is 'up'. <g>
Best,
DD
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.