In the last episode (Feb 07), Cal Evans said:
> Does the post office offer this info? There used to be a service (Melissa)
> that had Lat. and Long. for the center of each zip code. You could use that
> to computer "all addresses in a 50 mile radius". but from what I understand,
> it's gone now.
ilto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 15:32
> To: The Tilghman; 'Cindy'; [EMAIL PROTECTED]
> Subject: RE: slicing strings for comparison?
>
>
> Does the post office offer this info? There used to be a
> service (Melissa)
> that had Lat. and
re I could make these kind
of comparisons. Gotta URL ?
Cal
http://www.calevans.com
-Original Message-
From: The Tilghman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 2:26 PM
To: 'Cindy'; [EMAIL PROTECTED]
Subject: RE: slicing strings for comparison?
Check ou
> three digits, dash, four digits). I want to compare the second
> set of three digits to each other, something like
>
> WHERE Interviewee.homephone[4-6] = Interviewer.homephone[4-6]
>
> Similarly for zip codes, I want to compare the first three characters
> of a char[10] (zip plus 4], essen
to be accurate.
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Cindy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 13:33
> To: [EMAIL PROTECTED]
> Subject:
I have a select I'd like to do...I have 2 kinds of people -- those
needing interviews, and those doing interviews. Among other things,
each person has their home address/phone in the tables. I want to
generate lists of interviewers in close geographical proximity to the
interviewees. I can do