""David K. Trudgett"" <dkt@...> wrote in message
news:20020212090833.C9371@......

> On Monday 2002-02-11 at 09:13:48 -0000, Jason Chapman (JAC2) wrote:
>
> > >
> > > IF (OLD.mast_Column_Name IS NULL OR
> > > NEW.mast_Column_Name IS NULL) THEN
> > I don't understand this line
>
> The reason for it is that NULL does not equal NULL. See below.

You'll have to wait for coalesce(), then. Or have fun with the *nvl
functions in the fbudf, but they are tricky.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing