Recital Operators

Recital Operators

Assignment Operators

Values are assigned to memory variables using the the equals = operator or the inline assignment := operator.

cVAR1 = 'newer value'
cVAR1 := 'newest value'

Note that the store command can also be used to assign valuesand can operate on more than one memory variable in a single command.

store 'new value' to cVAR1, cVAR2

Arithmetic Operators

Recital supports the use of the following Arithmetic Operators:

Operator	Operation	Precedence
()	Parentheses	1
**	Exponentiation	2
*	Multiplication	3
/	Division	3
%	Modulus/Remainder	3
+	Addition	4
-	Subtraction	4

When dealing with Date data types, the operators work as follows:

Operator	Operation
+	<expD> + <expN> returns a date plus the number of days specified in <expN>.
-	Returns the interval between the two dates as a number of days.

Example

? 2*3^2
        18
? 2*25%7
      1.00
? date() + 30 - date()
        30

Comparison Operators

The following Comparison Operators are supported in Recital:

Operator	Operation
=	Equal To
==	Exactly Equal To / Matches Pattern
<>	Not Equal To
!=	Not Equal To
#	Not Equal To
>	Greater Than
>=	Greater Than or Equal To
<	Less Than
<=	Less Than or Equal To

The Comparison Operators are always evaluated from left to right.

String Concatenation Operator

When dealing with string data types, the + and - operators perform the following concatenation operations:

Operator	Operation
+	Concatenate the right hand string to the end of the left hand string.
-	Concatenate the right hand string to the end of the left hand string after trimming the left hand string of trailing spaces.

Example

? [Hello] + [ ] + [ World]
Hello World
? [Hello     ] - [ World]
Hello World

String Search Operators

The following String Search Operators are supported in Recital:

Operator	Operation
$	Substring is Contained In
|	Contains Substring