BOOLEAN

Converts a value of a string into a boolean. 

Syntax

BOOLEAN(string, [format])

Inputs

• string - The string value that is converted to boolean. 

• format (optional) - The format used for conversion. Format must be enclosed by quotes, e.g. ”1;0”. 

Default formats

For all conversion functions that use a string as parameter, the [format] describes the format in which the input string value parameter is in. When not specifying a format, by default this format is used: 

• string to boolean - true;false. 

Return type

• boolean

Examples

• BOOLEAN(“1”,”1;0”) results in a boolean value TRUE.