One way could be to use an INSTEAD OF trigger
The below mentioned link could be of help to you
http://msdn.microsoft.com/en-us/library/ms175521%28v=sql.105%29.aspx
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/