At 11:00 AM 2/10/01 +1100, you wrote:

>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...)
>

I've got CASE, both varieties. Make me an offer...

Jim Starkey