"insert or update" in one step?

   Is there a way to do an "insert or update" statement in one step? i.e. I want to insert a certain row if it's not there, or else just update it, without doing a select first and then branching to either an insert or update.

   Thanks! - Todd (gdulli_at_zdnetmail.edu - change edu to com) Received on Wed May 30 2001 - 20:33:10 CDT