Upsolver SQLake
Contact Support
Search
⌃
K
Links
Overview
Get started
Deploying Upsolver on AWS
Connectors
Data ingestion
Data transformation
Quickstarts
How to guides
SQL command reference
Functions and operators reference
Logical operators and filter functions
Comparison functions and operators
Comparison operators
BETWEEN
IS NULL and IS NOT NULL
IS DISTINCT FROM and IS NOT DISTINCT FROM
IN
LIKE
Comparison functions
Conditional functions and expressions
Mathematical functions and operators
String functions and operators
Regular expression functions
Date and time functions
Interval functions
Aggregate functions
Array functions
URL functions
External APIs functions
Spatial functions
Structural functions
Type conversions functions
System Catalog
Job status
API Integration
CLI
FAQ
Troubleshooting
Upsolver cost estimate
Change log
Powered By
GitBook
Comment on page
Comparison functions and operators
This section describes the following comparison functions and operators:
Comparison operators
Range operator:
BETWEEN
IS NULL
and
IS NOT NULL
IS DISTINCT FROM
and
IS NOT DISTINCT FROM
IN
LIKE
Comparison functions
Previous
NOT
Next
Comparison operators
Last modified
2mo ago