|
Ispirer SQLWays Database Migration Software
ISNULL
Syntax
ISNULL(check_expr, replacement_value)
ISNULL replaces NULL with the specified replacement value. The function returns the value of check_expr if it is not NULL, otherwise, replacement_value is returned.
Example
This example selects title and price for all books. If the price for a given title is NULL, the price shown is 0.00.
Equivalents in other databases