DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Status

Reference

  1. Overview
    • SQL Command Reference
      • Function Reference
        • Summary of Functions
          • All Functions (Alphabetical)
            • Aggregate
              • Bitwise Expression
                • Conditional Expression
                  • [NOT] BETWEEN
                    • BOOLAND
                      • BOOLNOT
                        • BOOLOR
                          • BOOLXOR
                            • CASE
                              • COALESCE
                                • DECODE
                                  • EQUAL_NULL
                                    • GREATEST
                                      • IFF
                                        • IFNULL
                                          • [NOT] IN
                                            • IS [NOT] DISTINCT FROM
                                              • IS [NOT] NULL
                                                • IS_NULL_VALUE
                                                  • LEAST
                                                    • NULLIF
                                                      • NULLIFZERO
                                                        • NVL
                                                          • NVL2
                                                            • REGR_VALX
                                                              • REGR_VALY
                                                                • ZEROIFNULL
                                                                • Context
                                                                  • Conversion
                                                                    • Data Generation
                                                                      • Date & Time
                                                                        • Encryption
                                                                          • File
                                                                            • Geospatial
                                                                              • Hash
                                                                                • Metadata
                                                                                  • Numeric
                                                                                    • Regular Expressions
                                                                                      • Semi-Structured Data
                                                                                        • String & Binary
                                                                                          • System
                                                                                            • Table
                                                                                              • Window
                                                                                              • Class Reference
                                                                                                • Scripting Reference
                                                                                                  • General Reference
                                                                                                    • API Reference
                                                                                                      ReferenceFunction ReferenceConditional Expression

                                                                                                      Conditional Expression Functions¶

                                                                                                      Conditional expression functions return values based on logical operations using each expression passed to the function. For example, the BOOLOR function takes two numeric expressions and returns True if either (or both) of the expressions evaluate to a True (non-zero) value.

                                                                                                      • [ NOT ] BETWEEN

                                                                                                      • BOOLAND

                                                                                                      • BOOLNOT

                                                                                                      • BOOLOR

                                                                                                      • BOOLXOR

                                                                                                      • CASE

                                                                                                      • COALESCE

                                                                                                      • DECODE

                                                                                                      • EQUAL_NULL

                                                                                                      • GREATEST

                                                                                                      • IFF

                                                                                                      • IFNULL

                                                                                                      • [ NOT ] IN

                                                                                                      • IS [ NOT ] DISTINCT FROM

                                                                                                      • IS [ NOT ] NULL

                                                                                                      • IS_NULL_VALUE

                                                                                                      • LEAST

                                                                                                      • NULLIF

                                                                                                      • NULLIFZERO

                                                                                                      • NVL

                                                                                                      • NVL2

                                                                                                      • REGR_VALX

                                                                                                      • REGR_VALY

                                                                                                      • ZEROIFNULL

                                                                                                      Was this page helpful?

                                                                                                      Visit Snowflake
                                                                                                      Join the conversation
                                                                                                      Develop with Snowflake
                                                                                                      Share your feedback
                                                                                                      Read the latest on our blog
                                                                                                      Get your own certification
                                                                                                      Privacy NoticeSite Terms© 2023 Snowflake, Inc. All Rights Reserved.
                                                                                                      Language: English
                                                                                                      • English
                                                                                                      • Français
                                                                                                      • Deutsch
                                                                                                      • 日本語
                                                                                                      • 한국어
                                                                                                      • Português