> 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