You're welcome

>Thanks Sergey,
>
>I had tried the MAX() function but couldn't get it right, thanks again.
>
>>Neil,
>>
>>Try
>>

>>SELECT xmlpackages.pkey, location.siteid AS Site, location.sitename AS NAME, location.phone, ;
>>    location.contype AS contype, location.exevers AS ExeVersion, ;
>>    COUNT(clients.clientno) AS Qty ;
>>  FROM location ;
>>  JOIN clients ON clients.siteid=location.siteid ;
>>  WHERE location.exevers < ;
>>         (SELECT MAX(RTRIM(majver)+[.]+RTRIM(minver)+[.]+RTRIM(midver)) ;
>>                  FROM xmlpackages ;
>>                  WHERE xmlpackages.pkey between "1000" AND "1999" )
>>         AND location.ACTIVE ;
>>  GROUP BY location.siteid, location.sitename, location.phone,  location.contype, location.exevers ;
>>  ORDER BY location.sitename ;
>> INTO CURSOR curLocList
>>