Equivalent Predicate

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

Compares two values for equivalence.


Syntax

<equivalent predicate> ::=

EQUIVALENT ( <value expression>, <value expression> )


Notes

♦ The data types shall be comparable.
♦ The predicate evaluates to TRUE if the two values are equal, else to FALSE.
♦ Null values are considered equal in this predicate.


Examples

1) The following example selects students from Newport:

       SELECT studentID, studentName, city

       FROM students

       WHERE EQUIVALENT ( city, 'Newport' )


Conformance

NexusDB extensions

-

EQUIVALENT predicate
‹ Match PredicateupOdd 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.