At 10:55 AM 20/08/2004 -0400, you wrote:

>I've submitted this bug, #1012895, along with an ESQL C program that
>demostrates the problem.
>
>I also downloaded the FB 1.5.1.4481 source and poked briefly around the gpre
>souce directory. There is no COALESCE in the parser code, nor NULLIF. There
>is a CASE, but no matching WHEN. Sure enough, attempting to substitute CASE
>for COALESCE in ESQL, with or without WHEN, fails.

:-( Probably NULLIF, too, then. What about SUBSTRING?

I'm sure nobody will mind if you want to mod gpre. :-) I looked at the
source and it reminded me of my son's bedroom...

./heLen