Returns the modulo value, which is the remainder of dividing the first argument by the second argument. Equivalent to the |
NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Numeric Operators. |
Output: Returns remainder of the value 14
divided by 3
, which is 2
.
Argument | Required? | Data Type | Description |
---|---|---|---|
value1 | Y | string | The first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types. |
value2 | Y | string | The first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types. |
Integer or Decimal expressions, column references or literals.
Required? | Data Type | Example Value |
---|---|---|
Yes | Literal, function, or column reference returning an Integer or Decimal value | 15 |