Group Numeric Functions
Abs()
Determines the absolute value of a numeric expression.
Abs( <nExpression> ) --> nPositive
BAnd()
Calculates the result of a bitwise AND operation.
BAnd( <nVa1>, <nVal2>, [<nVal3>,...] ) -> nBitwiseAnd
Bin2f()
Converts a 64 bit IEEE floating point number to a numeric value.
Bin2f( <cFloat64> ) --> nNumeric
Bin2i()
Converts a signed 16 bit integer to a numeric value.
Bin2i( <cSignedInt> ) --> nSignedInt
Bin2l()
Converts a 32 bit signed integer (long) to a numeric value.
Bin2l( <cSignedInt> ) --> nSignedInt
Bin2u()
Converts a 32 bit unsigned integer to a numeric value.
Bin2u( <cUnsignedInt> ) --> nUnsignedInt
Bin2w()
Converts a 16 bit unsigned integer to a numeric value.
Bin2w( <cUnsignedInt> ) --> nUnsignedInt
BOr()
Calculates the result of a bitwise OR operation.
BOr( <nVa1>, <nVal2>, [<nVal3>,...] ) -> nBitwiseOr
BXOr()
Calculates the result of a bitwise XOR operation.
BXOr( <nVa1>, <nVal2>, [<nVal3>,...] ) -> nBitwiseXOr
Exp()
Calculates the value of e to the power of x
Exp( <nExponent> ) --> nAntilogarithm
F2Bin()
Converts a numeric value to a 64 bit IEEE floating point number.
F2bin( <nNumeric> ) --> cBinary
I2bin()
Converts a numeric value to 16 bit integer.
I2bin( <nInteger> ) --> cBinary
Int()
Converts a numeric value to an integer numeric value.
Int( <nExpression> ) --> nInteger
L2bin()
Converts a numeric value to 32 bit integer.
L2bin( <nInteger> ) --> cBinary
Log()
Calculates the natural logarithm of a numeric value.
Log( <nExpression> ) --> nNaturalLog
Max()
Determines the larger of two numeric or two date values.
Max( <ndExpression1>, <ndExpression2> ) --> ndMax
Min()
Determines the smaller of two numeric or two date values.
Min( <ndExpression1>, <ndExpression2> ) --> ndMin
Mod()
Determines the modulus of two numbers in the same manner as dBASE III PLUS.
Mod( <nDividend>, <nDivisor> ) --> nRest
RandomInt()
Calculate a random numeric value
RandomInt( [<nInt>[,<nInt2>]] ) --> nRand
Round()
Rounds a numeric value to a specific number of decimal places.
Round( <nValue>, <nDecimals>) --> nRoundedValue
Sqrt()
Calculates square root of a positive number.
Sqrt( <nValue> ) --> nSquareRoot
U2bin()
Converts an unsigned numeric value to a 32 bit integer.
U2bin( <nInteger> ) --> cBinary
W2bin()
Converts an unsigned numeric value to a 16 bit integer.
W2bin( <nInteger> ) --> cBinary