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

select fp_dlvdat, fp_prccorn, fp_prcsoy ;
	FROM feedpric t1 ;
  where fp_dlvdat == ;
  (SELECT MAX(fp_dlvdat);
	FROM feedpric t2 ;
	where t1.fp_prccorn == t2.fp_prccorn and t1.fp_prcsoy == t2.fp_prcsoy) ;
	INTO CURSOR result	

PS: http://www.foxyclasses.com/sql_date.htm

Cetin