| title | ISNULL (SSIS Expression) | ||
|---|---|---|---|
| description | ISNULL (SSIS Expression) | ||
| author | chugugrace | ||
| ms.author | chugu | ||
| ms.date | 03/04/2017 | ||
| ms.service | sql | ||
| ms.subservice | integration-services | ||
| ms.topic | concept-article | ||
| helpviewer_keywords |
|
[!INCLUDEsqlserver-ssis]
Returns a Boolean result based on whether an expression is null.
ISNULL(expression)
expression
Is a valid expression of any data type.
DT_BOOL
This example returns TRUE if the DiscontinuedDate column contains a null value.
ISNULL(DiscontinuedDate)
This example returns "Unknown last name" if the value in the LastName column is null, otherwise it returns the value in LastName.
ISNULL(LastName)? "Unknown last name":LastName
This example always returns TRUE if the DaysToManufacture column is null, regardless of the value of the variable AddDays.
ISNULL(DaysToManufacture + @AddDays)