> 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
