IS_NULL

All functions > COMPARISON > IS_NULL

Returns TRUE if the expression evaluates to NULL.

Syntax

IS_NULL(expression: T) → BOOLEAN
sql

Type Parameters:

  • T: Any type

Arguments

ParameterTypeRequiredDescription
expressionTYesExpression to test for NULL

Returns

BOOLEAN - TRUE if NULL, FALSE otherwise

Notes

  • Only reliable way to test for NULL values
  • Using = NULL or != NULL always returns NULL, not TRUE/FALSE
  • Works with any data type
  • Never returns NULL itself - always returns TRUE or FALSE
  • Can use operator syntax: expression IS NULL
Suggest changes to this page
Last update at: 2025/10/13 10:23:46