Group Numeric Functions

Determines the absolute value of a numeric expression.

Abs( <nExpression> ) --> nPositive

Calculates the result of a bitwise AND operation.

BAnd( <nVa1>, <nVal2>, [<nVal3>,...] ) -> nBitwiseAnd

Converts a 64 bit IEEE floating point number to a numeric value.

Bin2f( <cFloat64> ) --> nNumeric

Converts a signed 16 bit integer to a numeric value.

Bin2i( <cSignedInt> ) --> nSignedInt

Converts a 32 bit signed integer (long) to a numeric value.

Bin2l( <cSignedInt> ) --> nSignedInt

Converts a 32 bit unsigned integer to a numeric value.

Bin2u( <cUnsignedInt> ) --> nUnsignedInt

Converts a 16 bit unsigned integer to a numeric value.

Bin2w( <cUnsignedInt> ) --> nUnsignedInt

Calculates the result of a bitwise OR operation.

BOr( <nVa1>, <nVal2>, [<nVal3>,...] ) -> nBitwiseOr

Calculates the result of a bitwise XOR operation.

BXOr( <nVa1>, <nVal2>, [<nVal3>,...] ) -> nBitwiseXOr

Calculates the value of e to the power of x

Exp( <nExponent> ) --> nAntilogarithm

Converts a numeric value to a 64 bit IEEE floating point number.

F2bin( <nNumeric> ) --> cBinary

Converts a numeric value to 16 bit integer.

I2bin( <nInteger> ) --> cBinary

Converts a numeric value to an integer numeric value.

Int( <nExpression> ) --> nInteger

Converts a numeric value to 32 bit integer.

L2bin( <nInteger> ) --> cBinary

Calculates the natural logarithm of a numeric value.

Log( <nExpression> ) --> nNaturalLog

Determines the larger of two numeric or two date values.

Max( <ndExpression1>, <ndExpression2> ) --> ndMax

Determines the smaller of two numeric or two date values.

Min( <ndExpression1>, <ndExpression2> ) --> ndMin

Determines the modulus of two numbers in the same manner as dBASE III PLUS.

Mod( <nDividend>, <nDivisor> ) --> nRest

Calculate a random numeric value

RandomInt( [<nInt>[,<nInt2>]] ) --> nRand

Rounds a numeric value to a specific number of decimal places.

Round( <nValue>, <nDecimals>) --> nRoundedValue

Calculates square root of a positive number.

Sqrt( <nValue> ) --> nSquareRoot

Converts an unsigned numeric value to a 32 bit integer.

U2bin( <nInteger> ) --> cBinary

Converts an unsigned numeric value to a 16 bit integer.

W2bin( <nInteger> ) --> cBinary