Compares one value to a specified range of values. Syntax expression [NOT] BETWEEN expr1 AND expr2 Parameters expression An expression that evaluates to either a number or a character string. expr1 An expression that evaluates to either a number or a character string. expr2 An expression that evaluates to either a number or a character…
Leia mais
Alters the order of evaluation of expressions, or groups expressions, or both. Syntax #1 Alters the order of evaluation in expressions. (expression) Within a larger expression, a single expression placed in parentheses changes the order of execution (which normally depends on the precedence of operators). Parameters expression an arithmetic or logic expression Syntax #2 Groups…
Leia mais
Performs a Boolean OR of two logic expressions. Syntax expression1 OR expression2 Parameters expression1 A logic expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses. expression2 A logic expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses. Return Value…
Leia mais
Performs a Boolean XOR of two logic expressions. Syntax expression1 XOR expression2 Parameters expression1 Any conditional expression or Boolean expression. If the expression is complex, it must be enclosed in parentheses. expression2 Any conditional expression or Boolean expression. If the expression is complex, it must be enclosed in parentheses. Return Value Logical as follows: Truth…
Leia mais
Compares two expressions and returns a value of “true” or “false”. Syntax expression1 = < <= <> > >= expression2 Parameters expression1 any value expression expression2 any value expression Return Value Logical Comments In a conditional expression, the less than sign (<) compares the expressions to its left and right, and is logically true if…
Leia mais
Checks a value to see if it is $Null. Syntax expression IS [NOT] $NULL Parameters expression Any expression. Return Value Logical. Comments An IS $NULL comparison is logically true if expression is valueless (unassigned). If expression has been assigned any value (including the null string), then the comparison is logically false. An IS NOT $NULL…
Leia mais
Controls the evaluation of other expressions. Syntax expression1 WHERE expression2 Parameters expression1 A value expression. expression2 A logic expression using conditional and Boolean operators. Return Value If expression2 is logically true, the value of expression1; otherwise, $Null. Example let i = { 1 where Age < 10, 2 where Age between 10 and 30, 4 where…
Leia mais
Matches an expression to a pattern. Syntax expression [NOT] LIKE pattern Parameters expression An expression that evaluates to a character string. pattern An expression that evaluates to a character string. Pattern must consist of combinations of letters, digits, symbols, and the special wildcard characters % and _. Return Value Logical. Comments A LIKE comparison is…
Leia mais
Compares one value to a list of values. Syntax expression [NOT] IN («expr») Parameters expression An expression that evaluates to either a number or a character string. expr A list of expressions whose values are to be compared to expression. Members of the list are separated from one another by commas. Return Value Logical Comments…
Leia mais
Multiplies one value by another. Syntax [expression1]*expression2 The asterisk (*) multiplies the expression on the left by the expression on the right. Parameters expression1 a number or expression that evaluates to a number expression2 a number or expression that evaluates to a number Comments Arithmetic operators indicate the sign of a number or perform arithmetic…
Leia mais
Portuguese 
English