Categories:

Semi-structured Data Functions (Cast)

AS_BOOLEANΒΆ

Casts a VARIANT value to a BOOLEAN value.

See also:

AS_<object_type>

SyntaxΒΆ

AS_BOOLEAN( <variant> )
Copy

ArgumentsΒΆ

variant

This should be an expression that evaluates to a VARIANT that contains a valid BOOLEAN value.

ReturnsΒΆ

The data type of the returned value is BOOLEAN.

ExamplesΒΆ

Here is a simple example of using AS_BOOLEAN:

SELECT AS_BOOLEAN(TO_VARIANT(TRUE)), AS_BOOLEAN(TO_VARIANT(FALSE)), AS_BOOLEAN(TO_VARIANT(NULL));
+------------------------------+-------------------------------+------------------------------+
| AS_BOOLEAN(TO_VARIANT(TRUE)) | AS_BOOLEAN(TO_VARIANT(FALSE)) | AS_BOOLEAN(TO_VARIANT(NULL)) |
|------------------------------+-------------------------------+------------------------------|
| True                         | False                         | NULL                         |
+------------------------------+-------------------------------+------------------------------+
Copy