Table of ContentsPreviousNext

Ispirer             Ispirer

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. 

SELECT title, ISNULL(price, 0.00) AS price
FROM titles

Equivalents in other databases

TABLE 92. Equivalents in other databases
IBM DB2
COALESCE function
Oracle
NVL function

Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.