something like "update duplicates" but better?

[Sven Köhler]

hi,

is there something like INSERT UPDATE DUPLICATES, which does _not_ 
replace the whole row, but only updates the given fields?

i want to execute something like
  INSERT table(key, field) VALUES(1, 'text')
if that fails, because of a key-collision, i should perform something like
  UPDATE table(field) VALUES('text') WHERE key=1
is this possible somehow with one statement?

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general