I have a table of zip codes that I want to group in two ways
(1) by all five characters
(2) by the first 3 characters
so that I can create pre-sort bulk mail bundles...
can anyone help with teh sql
to group for the entire zip I am using
select zip,count(*) for 'ziptable' group by zip
|