- Categories:
AS_BOOLEANΒΆ
Casts a VARIANT value to a BOOLEAN value.
- See also:
SyntaxΒΆ
AS_BOOLEAN( <variant> )
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 | +------------------------------+-------------------------------+------------------------------+