Numeric

This page describes how to use numeric functions in Lenses SQL Processors.

%	The remainder operator (%) computes the remainder after dividing its first operand by its second i.e. numExpr % numExpr	✓	✓
/	Divides one number by another (an arithmetic operator) i.e. numExpr / numExpr	✓	✓
-	Subtracts one number from another (an arithmetic operator) i.e. numExpr - numExpr	✓	✓
*	Multiplies one number with another (an arithmetic operator) i.e. numExpr * numExpr	✓	✓
+	Adds one number to another (an arithmetic operator) i.e. numExpr + numExpr	✓	✓
- (negative)	Returns the negative of the value of a numeric expression (a unary operator) i.e. -numExpr	✓	✓