`sql_ge(X;Y)`

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

Syntax

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

For null comparison, a column of results using the operator >= (greater than or equal to) is provided for comparison. For more information, see >= (greater 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="sqlge" label="SQL Null" value="sql_ge(colx;coly)"/>
<willbe name="greatorequal" label="Null" value="colx >= coly"/>