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/12/05 16:03:14
Last updated: 2025-12-05 16:07:55