IsNull function in DB2 SQL?

sql null db2
Dave picture Dave · Sep 15, 2008 · Viewed 122.2k times · Source

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

Answer

MadMurf picture MadMurf · Jul 14, 2009

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.

Related questions

Is Null Greater Than Any Date Data Type?

I have this query in DB2 SELECT * FROM SOMESCHEMA.SOMETABLE WHERE SYSDATE > @A If the SYSDATE is NULL, would it be greater than any value of @A, assuming that @A and SOMESCHEMA.SOMETABLE.SYSDATE is a Date data type? …

Read More
db2 query condition where column not in () while the column value is null

Good day, I have a row of data with a column, call status, the value inside is null. If I query select * from table where status not in ('EXP'), before I run this query, I thought I can select the …

Read More
How to use NULL or empty string in SQL

I would like to know how to use NULL and an empty string at the same time in a WHERE clause in SQL Server. I need to find records that have either null values or an empty string. Thanks.

Read More