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