TurboDB Engine Documentation

TurboPL Arithmetic Operators and Functions

Previous  Top  Next

These arithmetic operators and functions can be used in TurboPL expressions. They are no more recommended for TurboSQL.

Operators

+

Addition

-

Subtraction

*

Multiplication

/

Real division

div

Integer division

mod

Remainder

Comparisons

<

less

<=

less or equal

=

equal

>=

greater or equal

>

greater

less

less

is

equal

greater

greater

<>

not equal

from...upto

range test

in [...]

set test

Functions

Abs(X: Real): Real

Returns the absolute value of the argument X.

ArcTan(X: Real): Real

Returns the arctangent of a given X.

Cos(X: Real): Real

Returns the cosine of the angle X, in radians.

Exp(X: Real): Real

Returns the value of e raised to the power of X, where e is the base of the natural logarithm.

Frac(X: Real): Real

Returns the fractional part of the argument X.

Int(X: Real): Integer

Returns the integer part of X, that is, X rounded toward zero.

Log(X: Real): Real

Returns the natural log of a real expression.

Round(X: Real; [Scale: Integer]): Real

Returns the value of X rounded to the nearest number with the given scale. Scale can be negative as well.

Sin(X: Real): Real

Returns the sine of the angle in radians.

Sqrt(X: Real): Real

Returns the square root of X.

Compatibility Information

TurboPL is supported only for backward compatibility in tables up to level 4.