XLeratorDB/math Documentation
ODD
Updated: 17 august 2010
Use ODD to calculate a number rounded up to the nearest odd integer.
Syntax
SELECT [westclintech].[wct].[ODD] (
<@Number, float,>)
Arguments
@Number
is the value to round. @Number is an expression of type float or of a type that can be implicitly converted to float.
Return Types
float
Remarks
· The term rounding up always means rounding away from zero
Example
SELECT wct.ODD(-1.1)
Here is the result set
----------------------
-3
(1 row(s) affected)