Specify a test for odd numbers.

 

Syntax

 

<odd predicate> ::= ODD ( <numeric value expression> )

 

 

Notes

 

The data type shall be numeric.



 

The predicate evaluates to TRUE if the value is an odd number, else to FALSE.



 

If the given value is null, then the predicate evaluates to UNKNOWN.



 

 

Examples

 

1)

The following example selects students with odd studentID:



 


SELECT studentID, studentName


FROM students


WHERE ODD( studentID )



 

 


 

Conformance

 

NexusDB extensions

-

ODD predicate