Hello, I was wondering about this for a while, as Derby seems to be the only RDBMS I know that does not support the "simple syntax" for CASE clauses:
CASE [expression] WHEN [expression] THEN [expression] WHEN [expression] THEN [expression] ... See also https://issues.apache.org/jira/browse/DERBY-1576 I know that all of these RDBMS support it: DB2, H2, HSQLDB, MySQL, Oracle, Postgres, SQLite, SQL Server, Sybase. Are there any plans to implement that? Cheers Lukas
