Work's fine Thanks.
--- In [email protected], "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 >
