IS_NOT_NULL

All functions > COMPARISON > IS_NOT_NULL

Returns TRUE if the expression does NOT evaluate to NULL.

Syntax

IS_NOT_NULL(expression: T) → BOOLEAN
sql

Type Parameters:

  • T: Any type

Arguments

ParameterTypeRequiredDescription
expressionTYesExpression to test for non-NULL

Returns

BOOLEAN - TRUE if not NULL, FALSE otherwise

Notes

  • Opposite of IS_NULL function
  • Only reliable way to test for non-NULL values
  • Using != 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 NOT NULL
Suggest changes to this page
Last update at: 2025/10/13 10:23:46