Hello Jonathan,

Friday, September 10, 2004, 6:13:40 AM, you wrote:

> Alright then. Actually, I must admit that I'm not familiar with
> Coalesce()... what does it do exactly?

The description is in the FB1.5 release notes, and in Helen's book.

Here's a simple example of the usage:

Value1 = NULL;

COALESCE(Value1, 0) will return the value 0.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)