Hi All:

How do you retrieve the record that has the latest date from a table? I thought you use the MAX function but the following code gives me all the records from the table.

Thanks,

Yossi

SELECT MAX(fp_dlvdat), fp_prccorn, fp_prcsoy ;
	FROM feedpric ;
	GROUP BY fp_prccorn, fp_prcsoy ;
	INTO CURSOR result