Specifications
Operators used in InfoMaker expressions
624 InfoMaker
If you use a logical operator with a boolean function that returns null, the term
with the null return value is evaluated as
false. If you use the NOT logical
operator with a boolean function that returns
null, the complete term evaluates
to
true. For example, NOT gf_boolean () evaluates to true when gf_boolean
returns
null.
Concatenation operator in InfoMaker expressions
The concatenation operator joins the contents of two variables of the same type
to form a longer value. You can concatenate strings and blobs.
To concatenate values, you use the plus sign (+) operator.
Table 23-11: Using expressions with concatenation operator
Using quotes
You can use either single or double quotes in string expressions. For example,
the expression "over" + "stock" is equivalent to the expression
'over' +
'stock'.
FALSE AND FALSE FALSE
TRUE OR TRUE TRUE
TRUE OR FALSE TRUE
FALSE OR TRUE TRUE
FALSE OR FALSE FALSE
NOT TRUE AND TRUE FALSE
NOT TRUE AND FALSE FALSE
NOT FALSE AND TRUE TRUE
NOT FALSE AND FALSE FALSE
NOT TRUE OR TRUE TRUE
NOT TRUE OR FALSE FALSE
NOT FALSE OR TRUE TRUE
NOT FALSE OR FALSE TRUE
If one expression
has this value
And the
logical
operator is
And if another
expression has
this value
The resulting
expression has
this value
String expression Value
"over" + "stock" overstock
Lname + ', ' + Fname If Lname is Hill and Fname is Craig, then "Hill, Craig"