--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:
>
>
> > How can I know if a have differences changing from a null value to any value
> > (not null)
> >
> > example:
> > old.idnomencladoraux = null
> > new.idnomencladoraux = '420101'
> >
> > or
> > old.idnomencladoraux = '420101'
> > new.idnomencladoraux = null
> >
> > works fine
> > old.idnomencladoraux = '420101'
> > new.idnomencladoraux = '420102'
>
> if (old.descripcionaux IS DISTINCT FROM new.descripcionaux) then
>
>
>
> Sean
>