Re: How do I do this (SQL & Triggers)??

Dear John, I think this can be done using a business rule at the database table end itself. I donot have the exact syntax but at the time of creating the table you can set some checks. One of this could be a check for NULL and if true then replace the field to be entered to be some other field or any other value. Dilip At 02:54 23/09/96 -0700, you wrote: }I need to have an insert trigger which checks to see if a particular }field is NULL. If this field is NULL, I need to have it made equal }to the value of another field from the same row. Having putzed }around with this for a while using a combination of triggers and }stored procedures, I am beginning to believe that it is not possible. } Tell me it ain't so. } }My work news server has been down for the past few days, with no }reserection date in sight, so it would be appreceiated if replies }were sent to me directly at: gose_jo@leg.wa.gov } }TIA. } }John Gose } }"I've been there, and I'm back" } }