All functions > CONVERSION > NULL

Returns a NULL value of the given type.

Syntax

NULL(type: TYPE) → T
sql

Type Parameters:

  • T: Any expression type

Arguments

ParameterTypeRequiredDescription
typeTYPENoThe data type for the NULL value

Returns

A NULL value of the specified type

Notes

  • Creates a typed NULL value
  • If no type specified, defaults to VARCHAR
  • Useful for providing explicit NULL values in expressions
  • Type parameter ensures proper type inference in complex queries
  • NULL values propagate through most operations
  • Can be used to initialize optional fields or provide default values
Suggest changes to this page
Last update at: 2025/10/13 10:23:46