`sql_le(X;Y)`

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

Syntax

sql_le(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_le(X;Y) returns a boolean value of 1 if X is less than or equal to Y and 0 if X is greater than Y.

The data type of the result is integer.

If X or Y is N/A, the result is 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 or equal to the coly values.

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

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