How do I do this in SQL??

I want to create an insert trigger. The trigger needs to test for NULL in one of the fields of the record to be inserted. If the field is NULL, I want to set the value of the field equal to the value of another field in the same record. TIA John Gose gose_jo@leg.wa.gov -- "Feed your head." Door Mouse