Query_Lang-SystemFunctions_Arithmetic_ZEROZERO_AD
Created: September 05, 2015 | Updated: August 13, 2021
| Applies to versions: 1.0, 1.1, 2.0, 2.1, 3.0, 3.1 and 3.2
Now reading version 3.2. For the latest, read: Query_Lang-SystemFunctions_Arithmetic_ZERO((ZERO))_AD for version 4
Parent page: System Query Functions - Arithmetic Functions
Summary
Returns an integral number whose value is either 0 or 1, depending upon the parameter's numeric value. If that numeric value is zero, the number returned is 0; otherwise the number returned is 1.
Syntax
ZERO(X : Number / Numeric_String) : Number
Example Usage
ZERO(5.33)
Returns 1.
ZERO(-5.33)
Returns 1.
ZERO(0)
Returns 0.