Firebolt Documentation home page
Search...
⌘K
Ask AI
Contact us
Book a demo
Book a demo
Search...
Navigation
Conditional and miscellaneous functions
Conditional and miscellaneous functions
Documentation
Firebolt Core
📰 Blog
What is Firebolt?
Overview
Platform capabilities
Overview
Overview
Architecture
Pricing and billing
Organizations and accounts
Engine Fundamentals
Data modeling
Data management
Queries
Table and Column Compression
Security
Guides
Run queries
Manage organization
Get started
Operate Engines
SQL Dialect
Load data
Export data
Configure security
Develop with Firebolt
Integrate with Firebolt
Migrate to Firebolt
SQL reference
Overview
Data types
Information schema
Operators
SQL commands
SQL functions
Overview
Functions glossary
Aggregation functions
Array functions
Binary functions
Conditional and miscellaneous functions
Overview
CASE
CAST
CITY_HASH
COALESCE
GREATEST
HASH
IF
IFNULL
LEAST
NULLIF
TRY_CAST
TYPEOF
VERSION
DataSketches functions
Date and time functions
Geospatial functions
JSON functions
Lambda functions
Numeric functions
Session functions
String functions
Table-valued functions
Vector functions
Window functions
General reference
Overview
Release notes
Available regions
System settings
Object identifers
Reserved words
Arithmetic with intervals
Help menu
API reference
Overview
Synchronous queries
Asynchronous queries
On this page
Conditional and miscellaneous functions
Conditional and miscellaneous functions
Conditional and miscellaneous functions
Reference for conditional and miscellaneous functions
Conditional and miscellaneous functions
Assistant
Responses are generated using AI and may contain mistakes.
ENCODE
CASE