More function than FLOOR() !
On Mon, 4 Aug 2008 18:15:11 -0700 (PDT), joeu2004 wrote:
No. You could just try it yourself.
I did.
All of the OP's examples were integer. So it is unclear what the OP
wants to do, for example, with 10.99 and if that is even a relevant
question in the context. If it is, I ass-u-me that the OP knows that
FLOOR "rounds down" (truncates), according to the help text.
Your method converts anything less than 11 to 0; anything less than 21 to 10
I guess I would have "ass"-umed, from the way the question was posed, than
values over 10 should convert to 10.
But I would agree that his description was ambiguous for handling values 10
and <11.
--ron
|