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 Oracle to SQL Server Migration overview.

Ispirer SQLWays Database Migration Software



COALESCE(expr, expr2 {, expr })

COALESCE returns the first argument that is not NULL. The arguments are evaluated in the order in which they are specified. This function is usually used to replace NULL values with a not NULL value.


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, COALESCE(price, 0.00) AS price
FROM titles;
TABLE 76. Equivalents in other databases
NVL function
Microsoft SQL Server
COALESCE and ISNULL functions

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.