>thanks so much for the info, it worked.
>now there is one more thing that i need to do, i need to add up total minutes for each city as well and put it in a column.
>
>SELECT State, PADR(City,30), COUNT(*) AS Hits, sum(call_duration) as minutes ;
> FROM MyTable ;
> ORDER BY Hits DESC ;
> GROUP BY State, City
>
>would that work?
>Ryan

SELECT State, PADR(City,30) AS City, ;
  COUNT(*) AS Hits, ;
  SUM(Call_Duration) as Minutes ;
  FROM MyTable ;
  <b>ORDER BY Minutes DESC</b> ;
  GROUP BY State, City