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

> Can this be done in one SELECT statement:-
>
>

>SELECT ALLTRIM(majver)+[.]+ALLTRIM(minver)+[.]+ALLTRIM(midver) as version ;
>TOP 1 ;
>FROM xmlpackages ;
>WHERE BETWEEN(xmlpackages.pkey,"1000","1999") ;
>ORDER BY 1 DESC INTO CURSOR curSelect nofilter
>
>SELECT curSelect
>
>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 ;
>	GROUP BY location.siteid, location.sitename, location.phone, ;
>	location.contype, location.exevers ;
>	WHERE location.exevers < curSelect.version AND location.ACTIVE=.T. ;
>	ORDER BY location.sitename ;
>	INTO CURSOR curLocList
>

>
>Thanks in advance