• You can use an INSTEAD OF trigger.

    --

    Chris Hedgate @ Extralives (http://www.extralives.com/)

    Co-author of Best of SQL Server Central 2002 (http://qa.sqlservercentral.com/bestof/)

    Articles: http://qa.sqlservercentral.com/columnists/chedgate/