Re: How to set a value when NULL

[sivapostg...@yahoo.com]

Hello,Need to set a value of Zero when the field value is NULL in trigger 
function.
Tried with,NEW.fieldname = NULLIF(NEW.fieldname, 0)
in before insert/update trigger.
Looks like it's not working.  I'm doing anything wrong.
Happiness AlwaysBKR Sivaprakash