| Function | Type | What it does |
|---|---|---|
case | Being confirmed | Previous docs; being confirmed. |
cast | Scalar | Converts a value to a requested SQL type. |
coalesce | Scalar | Returns the first non-NULL value from its arguments. |
current_catalog | Scalar | Returns the query’s current default catalog name. |
current_schema | Scalar | Returns the query’s current default schema name. |
decode | Scalar | Performs NULL-safe value selection or decodes bytes using a character set. |
equal_null | Scalar | Compares two values with NULL-safe equality. |
greatest | Scalar | Returns the greatest value among compatible arguments. |
if | Scalar | Returns one of two values according to a Boolean condition. |
iff | Scalar | Returns one of two values according to a Boolean condition. |
ifnull | Scalar | Returns the first value when it is not NULL, otherwise the replacement value. |
in | Being confirmed | Previous docs; being confirmed. |
isnull | Scalar | Tests whether a value is SQL NULL. |
least | Scalar | Returns the least value among compatible arguments. |
not | Being confirmed | Previous docs; being confirmed. |
nullif | Scalar | Returns NULL when two values are equal, otherwise returns the first value. |
nvl | Scalar | Returns the first value when it is not NULL, otherwise the replacement value. |
nvl2 | Scalar | Returns one value for a non-NULL input and another for a NULL input. |
to_boolean | Being confirmed | Previous docs; being confirmed. |
try_cast | Scalar | Converts a value to a requested SQL type and returns NULL for failed supported conversions. |
try_to_number | Scalar | Parses a string as a number and returns NULL if parsing fails. |
typeof | Scalar | Returns the SQL type name of an expression. |
zeroifnull | Scalar | Returns zero for NULL input and otherwise returns the input value. |
Conditional and conversion functions
Branch on conditions, handle NULLs, cast between types and read session context.
Branch on conditions, handle NULLs, cast between types and read session context.
Last modified on October 15, 2026