NUM_COMPARE Function

Parameters: (Decimal, String, Decimal);

Returns: Boolean;

Function to compare two numeric values.

The first parameter is the first value to be compared.

The second parameter is the comparison operator.

The second parameter is the second value to be compared.

Returns NULL if either value or the operator is NULL.

Otherwise returns the boolean result of value1 <operator> value2.

Examples:

Example 1:  NUM_COMPARE(12,'>',11) = FALSE

Example 2:  NUM_COMPARE(12,'=',12) = TRUE

Example 3:  NUM_COMPARE(NULL,'!=',11) = NULL