IBM® Informix® 12.10
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.