Odd Predicate

Wed, 03/04/2009 - 20:02 |  hdanzl

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
‹ Equivalent PredicateupInserting Predicate ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | Predicates

Powered by Drupal and Drupal Theme created with Artisteer.