hmm, Ok Matt thanks.

BEFORE triggers! I wish! Bloody SQL Server doesn't support them.

My triggers used to be "INSTEAD OF", but yeah I wasn't too impressed with the whole maintenance issue of keeping the insert within the trigger up to date with all the new columns added. Now if I could just write a DDL trigger to keep the DML trigger up to date when the table structure changes . . . 😉 shudder!