Howdy All,

  I getting update transactions from a flatfile, and want to use them to
update a table in a database.  However, I first need to check to see if the
proposed new key already exists on the table.  Obviously, there are many ways
to do this, but it must be a fairly common problem and was wondering if
anyone had looked into the most efficient mechanism?

Thanks,
   Marty