Hi All,
I have a table with a unique constraint. Is there any way in a trigger on
the table to convert an insert into an Update if the key value already
exists?
The idea is to update (the possibly changed) non unique columns, while
hiding this fact from the (possibly ISQL) user, and keep the client simple,
and rules in the server.

TIA
John