At 05:31 PM 09-02-01 -0500, you wrote:

>A place where this is particularly useful is a (non-standard)
>REPLACE verb, syntactically parallel to INSERT but does
>an UPDATE if a record with the same primary key exists,
>a non-op if it exists and nothing has changed, otherwise
>an INSERT. Trivial to implement, saves a bundle of
>application level code, and fast to boot.

Yow! I want one! (Along with CASE and NULLIF for a perfick world...)

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________