>Thanks for the help and I have found a solution based on it as follows:
>
>

>scust.packageid + DTOS(scust.applicdt) IN ( ;
>        SELECT sc.packageid + DTOS(MAX(scust.applicdt)) ;
>		FROM a25scust sc ;
>		GROUP sc.packageid) AND ;
>

>
>Regards
>Bhavbhuti
And how is it different from what I sugested?