I second the suggestion to consider "instead of" triggers. I am currently adding / modifing some columns to the data that is being inserted and the "Instead of" trigger...