Re: JavaDB / Apache Derby equivalent to the SQL Server IsNull, Oracle nvl and MySQL IfNull

Lew wrote:

Have you tried the Derby documentation?

First, there's the standard SQL CASE construct, then there's the equivalent Derby function
<http://db.apache.org/derby/docs/10.3/ref/rrefcasenullif.html>

Manuals are a wonderful thing, aren't they? I have no familiarity with Derby and it took about five minutes to find.


I posted that link already and indeed nullif is *not* the function the James is looking for.

Actually I claimed that I could replace any occurance of nvl() with a case, but his example (posted on 14.08.2007 17:57) showed me that it's not that easy ;)

Thomas
.