What about in an INSTEAD-OF trigger?

INSTEAD OF triggers are different animals than AFTER triggers.

Two (of many) reasons for using INSTEAD OF triggers might be because you want to rollback transactions on tables that you don't want modified (and direct the data somewhere else), or if you want to create updateable views.