Operators (Magic xpa 3.x)
In Magic xpa expressions, you can use the following mathematical, logical, and string operators:
|
Mathematical Operators
|
Example
|
|
|
Addition
|
A+B+C
|
|
|
Division
|
A/B
|
The result of integer division is rounded to the nearest whole number.
|
|
Exponentiation
|
A^B returns A to the power of B.
|
|
|
Modulus
|
A MOD B
17 MOD 10 returns 7
|
Returns the remainder of an integer division.
See also: The Online and Rich Client Samples projects (program NM03 and RNM03)
|
|
Multiplication
|
A*B
|
|
|
Subtraction
|
A-B-C
|
|
|
Unary Negation
|
-(3)
|
Changes the sign of a Numeric expression.
|
|
String Operators
|
|
|
|
Concatenation
|
'John'&'Smith' yields 'JohnSmith'
|
Use the & symbol to concatenate (string together) Alpha strings.
|
|
LIKE
|
|
Determines whether a given character string matches a specified pattern.
|
|
Logical Operators
|
|
* All expressions involving logical operators return a logical TRUE or FALSE.
|
|
AND
|
|
Returns TRUE only if both operands are TRUE.
|
|
NOT
|
NOT ('FALSE'LOG) returns TRUE
NOT (A) Logical returns TRUE
|
Reverses the logical value of its operand.
|
|
OR
|
|
Returns TRUE only if either operand is TRUE.
|
|
Different Than
|
A<>B
|
Not equal to.
|
|
Equal To
|
A=B
|
|
|
Greater Than
|
A>B
|
|
|
Greater Than or Equal To
|
A>=B
|
|
|
Less Than
|
A<B
|
|
|
Less Than or Equal To
|
A<=B
|
|
