Hi!
I'm looking for a way to make
a conditional update on MS-SQL 2000.
The code below is what I tried but it doesn't
work.

thanks in advance,
Nir.


***********************
sale_date = date()
lcPk = "my primary key"

myResult = SQLExec(myConn, ;
"UPDATE products " + ;
"SET last_sale = IIF(last_sale>?sale_date,last_sale,?sale_date) " + ;
"WHERE pk_products = ?lcPk")
***********************