AS_CHAR , AS_VARCHAR¶

Syntax¶

AS_CHAR( <variant_expr> )

AS_VARCHAR( <variant_expr> )

Arguments¶

variant_expr

An expression that evaluates to a value of type VARIANT.

Returns¶

The function returns a value of type VARCHAR or NULL:

• If the type of the value in the variant_expr argument is CHAR or VARCHAR, the function returns a value of type VARCHAR.

• If the type of the value in the variant_expr argument doesn’t match the type of the output value, the function returns NULL.

• If the variant_expr argument is NULL, the function returns NULL.

Examples¶

Create a table and load data into it:

CREATE OR REPLACE TABLE as_varchar_example (varchar1 VARIANT);

INSERT INTO as_varchar_example (varchar1)
  SELECT TO_VARIANT('My VARCHAR value');

Use the AS_VARCHAR function in a query to cast a VARIANT value to a VARCHAR value:

SELECT AS_VARCHAR(varchar1) varchar_value
  FROM as_varchar_example;

+------------------+
| VARCHAR_VALUE    |
|------------------|
| My VARCHAR value |
+------------------+