simple max function?

From: Roedy Green (look-on_at_mindprod.com.invalid)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 02:01:32 GMT

This is not legit SQL. I wondered if you could do what I was
attempting here in one statement though.

conn.prepareStatement( "UPDATE vendors SET
highestVendorConfirm=MAX(?,highestVendorConfirm),
vendorTimestamp=MAX(?,vendorTimestamp) WHERE vendorId=?" );

I am using max not in the column-examining sense, but just a function
to pick the bigger of two numbers. 

-- 
Canadian Mind Products, Roedy Green.
Coaching, problem solving, economical contract programming. 
See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.