SELECT City, Zip=LEFT(Zip,5), MBRs=count(Zip)
FROM MasterAccounts
WHERE Active = 1 /* Display only "active" people) */
GROUP BY LEFT(Zip,5), City
ORDER BY LEFT(Zip,5), City
-----Original Message-----
From: keitenmiller@hughestech.net [mailto:keitenmiller@hughestech.net]
Sent: Friday, February 04, 2000 12:27 PM
To: emerald@iea-software.com
Subject: Re: [Emerald] SQL QUERY
Josh,
Looks good, but differentiates zip codes between 61111 and 61111-1111.
Is there a way to trim all charaters after the first 5 in the zip code
field?
Thanks,
Ken
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart