Boolean

The value derived from the function is a Boolean value. This value can be True or False.

This table shows the commands and the related syntax used for the Boolean data type:

Command Syntax Examples
Boolean String

A Boolean string can be specified and the value must be defined by the format for the data type.

 Format: Logical: True/False/No Value

 Text: Yes/No/- (these values can be specified using the defined values

 Numeric: 2/1/0

Logical Expression

Any logical expression can be used. 

<Logical expression>=
<value or expression> = <value or expression>
<value or expression> # <value or expression>
<value or expression> > <value or expression> 
<value or expression> < <value or expression>
<value or expression> >= <value or expression>
<value or expression> <= <value or expression>
<Logical expression> & <Logical expression> -> AND
<Logical expression> | <Logical expression> -> OR
<Logical expression> ^| <Logical expression> -> EXCLUSIVE OR
NOT(<Logical expression>) -> NEGATION

 It is recommended that you use the required brackets to make the interpretation unambiguous. 

~ = 566
("~" # "C") | (~ = 1) | (NOT(~ > 4))
((~ < 100) | (~ > 2)) & ((~ % 2) = 0)

 If the column type is numeric and you require that value to be interpreted as a string, include double quotes in the expression. If the type is already a string, do not include quotes.