Triggers

I've been reading the chapters on triggers and there's something I don't quite understand. What I'd like to do is the following: For a given table, if the record exists (table has primary key), UPDATE the record else INSERT a new record I wrote a stored proc to do this for a single table. I need to perform this operation in 50+ tables and I keep thinking I need a trigger (or triggers) on each of the tables, but I can't figure out how to create the trigger statement. ========= << raj >> == http://www.brainlink.com/~frostbit/ ============== SYSADMIN: BrainLINK System (718) 805-6559 // http://www.brainlink.com You want to be president? Yes. Put your hand on the book and say "I Do." I Do. Fine, done. Let's eat. - G'Kar & Sheridan ============================================================================