db2中null和空值的区别,DB2 SQL中的IsNull函数？

Is there a performant equivalent to the isnull function for DB2?

Imagine some of our products are internal, so they don't have names:

Select product.id, isnull(product.name, "Internal)

From product

Might return:

1 Socks

2 Shoes

3 Internal

4 Pants

解决方案

For what its worth, COALESCE is similiar but

IFNULL(expr1, default)

is the exact match you're looking for in DB2.

COALESCE allows multiple arguments, returning the first NON NULL expression, whereas IFNULL only permits the expression and the default.

Thus

SELECT product.ID, IFNULL(product.Name, "Internal") AS ProductName

FROM Product

Gives you what you're looking for as well as the previous answers, just adding for completeness.