how would I get the most frequent part of a feild (telephone cntrex).

I have some idea how to use "ORDER BY COUNT DESC LIMIT 1" but what if I
want to compare the first seven characters (ie, area code and
exchange) instead of the entire number?


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.facebook.com/vasjpan2
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos]

vjp2.at (AT) at (DOT) BioStrategist.dot.dot.com wrote:
...Left(Phone,7) as AreaPrefex, ....
or entering in a blank column
AreaPrefix : Left(Phone,7)
Assumes the field's name is phone

Many thanks.. BTW I was hoping to get only one value.. so I can build a pivot table..
(else 3d!)


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.facebook.com/vasjpan2
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos]

vjp2.at (AT) at (DOT) BioStrategist.dot.dot.com wrote:

Select Distinct fieldlist from Table...

Or make it a GroupBy/Totals query.