Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Returns a Boolean result based on whether an expression is null.
Syntax
ISNULL(expression)
Arguments
- expression
Is a valid expression of any data type.
Result Types
DT_BOOL
Examples
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)