The basic shell to an update trigger would be as follows:
CREATE TRIGGER YourTriggerName ON YourTableName FOR UPDATE
AS
Begin
Your logic here
End
Go
John Rowan
======================================================
====================================================== Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden