Table of ContentsPreviousNext

Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.
Ispirer SQL Server Migration overview.

Ispirer SQLWays Database Migration Software



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.


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
COALESCE function
NVL function

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