All functions > CORE > NULL
Returns a NULL value of the given type.
Signatures
Returns: A NULL value of the specified type
NULL([type: DataTypeEnum.TYPE]) → Tsql
| Parameter | Type | Required | Description |
|---|---|---|---|
type | DataTypeEnum.TYPE | No | The data type for the NULL value |
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
On this page