TO_BOOLEAN
Description
Converts a string into a Boolean value. If the input cannot be converted, the function returns an error.
Syntax
TO_BOOLEAN(string) -> Boolean
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| string | String | Yes | The string to convert into a Boolean. |
Example
TO_BOOLEAN("true")
-- Returns TRUE.Tips
The function returns TRUE if the input string, ignoring case, equals "true".
Any string that does not match "true" (case insensitive) returns FALSE.