Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 



ISNULL Function

Description

The ISNULL function performs a comparison to determine if the result of the expression specified as an argument is NULL. The function returns 1 if it is NULL or 0 otherwise. You can check if a certain value is NULL. This function is working like the ISNULL expression.

Syntax

ISNULL(expression)

  • expression : An arithmetic function that has a single-value column, path expression, constant value is specified.
Example

--Using ISNULL function to select rows with NULL value

SELECT * FROM condition_tbl WHERE ISNULL(salary);

           id  name                  dept_name                  salary

======================================================================

            7  'Brown     '          'account'                    NULL