TO_BOOLEAN

Converts a value to a boolean (true/false) format

Updated over a week ago

Description

The TO_BOOLEAN() function is used to convert a value, which may be in various formats, into a boolean (true/false) format. This is particularly useful when dealing with data that represents true/false conditions or needs to be evaluated as boolean values.

Syntax

TO_BOOLEAN(value)

Output

boolean

Variables

  1. value: The value you want to convert into a boolean. This can be a number, text.

Example

TO_BOOLEAN(`>80`)

Name

>80

TO_BOOLEAN(`>80`)

Giacomo

no

Kameko

no

Anne

no

Orlando

yes

TRUE

Nasim

no

Did this answer your question?