Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This function returns TRUE if all its arguments evaluate to TRUE; it returns FALSE if one or more arguments evaluate to FALSE.

Syntax

Code Block
argument1 AND argument2 [AND ...]
  • argument1 - The first boolean condition that you want to evaluate.
  • argument2 - The first boolean condition that you want to evaluate.
  • [AND …] - Additional boolean conditions that you want to evaluate.

Return type

  • boolean

Examples

  • TRUE AND TRUE results in TRUE
  • TRUE AND FALSE results in FALSE
  • TRUE AND ? (= UNKNOWN) results in FALSE (since the second argument is not equal to TRUE)UNKNOWN

OR

This function returns TRUE if at least one of its arguments evaluates to TRUE; it returns FALSE if none of the arguments evaluate to TRUE.

Syntax

Code Block
argument1 OR argument2 [OR ...]


argument1 - The first boolean condition that you want to evaluate. argument2 - The first boolean condition that you want to evaluate. [OR …] - Additional boolean conditions that you want to evaluate.

Return type

  • boolean

Examples

  • TRUE OR TRUE results in TRUE
  • TRUE OR FALSE results in TRUE
  • TRUE OR ? (= UNKNOWN) results in TRUE
  • FALSE OR ? (= UNKNOWN) results in FALSE (since none of the arguments is TRUE)

 

TRUE

...