Jump to main content
Yellowbrick Documentation
Product Documentation
yellowbrick.com
Technical Support
ⓘ
Documentation Version 5.2
Search
Home
Documentation Version 5.2
SQL Reference
SQL Functions and Operators
Conditional Expressions
Documentation Version 5.2
What's New in Version 5.2
System Management
Client Tools and Drivers
ybsql Reference
Database Administration
Loading and Unloading Data
Workload Management
Backup and Restore
Database Replication
SQL Reference
SQL Data Types
SQL Commands
SQL Functions and Operators
Supported Functions and Return Types
SQL Conditions
String Functions
Pattern Matching
Datetime Functions
Mathematical Functions
Aggregate Functions
Window Functions
Conditional Expressions
CASE
COALESCE
DECODE
GREATEST and LEAST
IIF
ISNULL
NULLIF
NVL
NVL2
Formatting Functions
Type-Safe Casting Functions
JSON Functions
CONVERT (SQL Server Migration Function)
GETBIT Function
NEXTVAL Function
System Functions
Network Address Functions
SQL Reserved Words
SQL Quick Reference
Error Codes
Glossary
Notices and Licenses
Conditional Expressions
This section describes special SQL expressions that evaluate conditions.
CASE
COALESCE
DECODE
GREATEST and LEAST
IIF
ISNULL
NULLIF
NVL
NVL2
