Store Locator

K

Kevin Spencer

Yes, since the numbers are aphabetically in the same order as numerically.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
 
K

Kevin Spencer

Yes, "simple" is one of the words I use to identify the level of the
developer. Pros generally avoid using the word, as they know better! ;-)

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

in message i think the only accurate way to do it would be with coordinates, as kevin
mentioned earlier.

funny how simple things aren't.

i'd run into this trying to coordinate an online car pool feature for my
son's high school...proved to be too daunting for the amount they were
paying (zippo) :)
 
M

Murray

Of course, then there is the potential problem when you have zips in NJ -
09513, for example. Numeric fields drop that leading zero.
 
K

Kevin Spencer

True. ZipCodes are stored as strings everywhere I've seen. You could still
use BETWEEN in the query though.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
 
K

Kevin Spencer

It works on strings. At least in some databases (e.g.SQL Server).

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
 
Top