NotEqual() function

The NotEqual( ) function compares two nodes to determine whether they are not equal. Implements the comparison operator and can be used in SQL statements either using the function name or the corresponding symbol. The opposite function is Equal().

Returns: Boolean

Syntax

NotEqual(node1, node2)

node1

The node against which you will test for inequality.

node2

The node that you will compare to the first to test for inequality.

Examples

SELECT * FROM tablename WHERE NotEqual(nodecolumn, '1.4');

SELECT * FROM tablename WHERE nodecolumn != '1.4';

This example is the same as Example 1, except a not equal sign is used in place of the function name.