>this is really close, the only problem is that there can be more than one city name in two different states. like a boston, MA and a boston, NY or something. and they need to be treated seperately. thanks for your help so much!
>Ryan
Ok. try again with
SELECT State, PADR(City,30), COUNT(*) AS Hits ;
FROM MyTable ;
ORDER BY Hits DESC ;
GROUP BY State, City
Luis María Guayán
Tucumán, Argentina
________________________________
SysOp de
www.PortalFox.comNada corre como un zorro
________________________________