`sql_l(X;Y)`

Returns a boolean value indicating if X is less than Y. This function has SQL-compatible null handling.

Syntax

sql_l(X;Y)

Input

Argument	Type	Description
`X`	any numeric type	The name of a column of values to compare to `Y`.
`Y`	any numeric type	The name of a column of values to compare to `X`.

Return Value

sql_l(X;Y) returns a boolean value of 1 if X is less than Y and 0 if X is greater than or equal to Y.

The data type of the result is integer.

If X or Y is N/A (null), the result is also N/A.

Example

In this example, the values in colx are compared to the values in coly to determine if the colx values are less than the coly values.

For null comparison, a column of results using the operator < (less than) is provided for comparison. For more information, see < (less than).

<table cols="colx,coly">
  899,3;
  38,38;
  21,770;
  95,152;
  2700,584;
  986,986;
  ,;
  ,9;
  66,;
</table>
<willbe name="sqll" label="SQL Null" value="sql_l(colx;coly)"/>
<willbe name="lessthan" label="Null" value="colx < coly"/>