<p>Is there a performant equivalent to the isnull function for DB2?</p>

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

<pre><code>Select product.id, isnull(product.name, "Internal) 
From product
</code></pre>

<p>Might return:</p>

<pre><code>1 Socks 
2 Shoes 
3 Internal 
4 Pants
</code></pre>

I'm not familiar with DB2, but have you tried COALESCE?
ie:
```
```
SELECT Product.ID, COALESCE(product.Name, "Internal") AS ProductName
FROM Product
```
```