Goto the downloads section of www.lelievre.net and get an updated zip_ file.
This has a fairly complete list of all the zip codes in the US. Each zip
code record also has fields for county, congressional district, time zone,
area code, etc.
If you haven't changed your current zip_ file, overwrite the old with the
new one (with ebase closed, of course). Then you could do a REPLACE of the
county field in the names_ file with the county data from the zips_ file.
If you aren't familiar with using the REPLACE command, just ask for more
details.
------------------------------------------------------------
Bob LeLievre
LeLievre Information Services
List Management Services for Non-Profits
voice: 617-474-9131
email: [EMAIL PROTECTED]
website: www.lelievre.net
-----Original Message-----
From: Oklahoma Wildlife Federation [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 5:23 PM
To: TechRocks Support
Subject: [support] Counties field
Ebasers,
I need to find all of our members in 22 counties. I have never added
anything to the County field in Ebase. I didn't even realize Ebase had a
spot for them.
I would like to be able to do a query in this field to find all our members
in these counties. Otherwise, I'll have to do each town. Is there a way to
do this?
Thanks,
Lance Meek
Oklahoma Wildlife Federation
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the
email address you used to subscribe to the ebase support list::
[EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
