BOOLEAN

has only two possible values: true and false.

LITERAL NOTATION: A Boolean value can be expressed using either upper or lowercase letters:

true or TRUE
false or FALSE

Conversion

1
2
BOOLEAN(string_expr)
BOOLEAN(numeric_expr)
  1. Converts string values T, t, Y, y, 1, YES, yes, TRUE, true to true Boolean value, other values to false.
  2. Converts value 0 to false Boolean value. Other input values are converted to Boolean true.

Expressions

1
2
3
4
boolean_expr1 AND boolean_expr2
boolean_expr1 OR boolean_expr2
boolean_expr1 XOR boolean_expr2
NOT boolean_expr

See also

Boolean

Parsing

1
BOOLEAN:fieldname

See also

BOOLEAN