LessThan() function

The LessThan( ) function compares two nodes to determine which is less. Implements the comparison operator and can be used in SQL statements either using the function name or the corresponding symbol.

Returns: Boolean

Syntax

LessThan(node1, node2)
node1
The node that you are will compare against.
node2
The node that you are checking to see if it is less than node1.

Examples

Example 1
SELECT * FROM tablename WHERE LessThan(nodecolumn, '1.4');
The following list includes nodes that are less than 1.4:
  1. 0.4
  2. 1.3
  3. 1.3.66
  4. 1.1.1.1
The following list includes nodes that are greater than 1.4:
  1. 1.4.1.1
  2. 1.5
  3. 2.0
Example 2
SELECT * FROM tablename WHERE nodecolumn < '1.4';