2.0 3.0 > cat > expressions
Anterior  Próximo  Editar  Renomear  Desfazer  Procurar  Administração
 Documentação
Expressions
An expression is a value (a constant, a predefined constant, a variable or the result of a function), which may optionally be preceded by certain operators depending on the type of value, followed by an operator and another value, and so on.

```For numeric expressions:
{ number | constant | numeric function | numeric variable } [ operator [ sign ] { number | numeric function | numeric variable} ... ]
Number : a standard Number
constant : a predefined constant that represents a numeric value
numeric function : a user-defined or Intrinsic Functions that returns a numeric value
operator : any of the standard arithmetic operators ( + - * / ^ \  DIV MOD plus AND OR or XOR)
numeric variable : any variable whose value is a number

For string expressions:
{ string | string constant | string function | string variable} [ & { string | string constant | string function | string variable} ... ]
string : a set of zero or more characters surrounded by "
string constant : a predefined constant that represents a string value
string function : a user-defined or Intrinsic Functions that returns a string value
string variable : any variable whose value is a string
& : indicates that the string value to the right of the ampersand is to be concatenated to the end of the value to the right of the ampersand

For boolean expressions:
[ NOT ] { TRUE | FALSE | numeric constant | boolean constant | boolean function | boolean variable } [ boolean operator [ NOT ] { TRUE | FALSE | numeric constant | boolean constant | boolean function | boolean variable } ... ]
NOT : using NOT before a boolean value reverses the value
TRUE or FALSE : the standard boolean constants
numeric constant : a standard number which will be resolved to either TRUE or FALSE[1]
boolean constant : a predefined constant that represents a boolean value
boolean function : a user defined or Intrinsic Functions that returns  TRUE or FALSE or resolves to  TRUE or FALSE[1]
boolean variable : any variable whose value is TRUE or FALSE or resolves either to TRUE or FALSE[1]
boolean operator: AND OR XOR = <> < > <= >=
Note that if the expression consists of a number with the operator AND, OR, or XOR followed by a number, it will be treated as an arithmetic expression rather than a boolean expression.  At least one of the values in the expression must be a boolean value to produce a boolean expression.

[1]Note that a Number, predefined constant, arithmetic function or numeric variable may be used as a boolean value.  If the value of a number, numeric constant, numeric function, or variable is used in a boolean expression is zero, it resolves to FALSE ; all other numeric values used in a boolean expression resolve to TRUE.```