Don't know who first posted this tip (hopefully no one will get ticked off
because I don't remember who). But it's an oldy but goody that I needed to
have today and never used before! So in case anyone else can use this
code....
I got a request to round a number up or down to the nearest .5 increment. Such
as:
9.05 9.0
19.61 19.5
3.7 3.5
3.9 4.0
0.37 0.5
Sure enough, found this lovely calculation in my notes:
select totaltimess, (.50 * (int( 2 * (totaltimess + .25)))) from tmphone
Works great!!
Karen
