Equal() function

The Equal( ) function compares two variable-length opaque types This function implements the comparison operator, so you can use it in SQL statements using the function name or the corresponding symbol.

Returns: Boolean

Syntax

Equal(node1,node2)
node
The node against which you will test for equality.
node2
The node that you will compare to the first to test for equality.

Examples

Example 1
SELECT * FROM tablename WHERE Equal(nodecolumn, “1.4”);
Example 2
SELECT * FROM tablename WHERE nodecolumn = “1.4”;

This example is the same as Example 1, except an equals sign is used.


Copyright© 2019 HCL Technologies Limited