Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 proximity search

Author  Topic 

mike123
Master Smack Fu Yak Hacker

1462 Posts

Posted - 2007-05-21 : 04:19:04

Not sure if this qualifies as a total SQL problem, but its definatley related. I'm looking for a way to do proximity searches, I have seen them on many websites but I'm unsure how to go about accomplishing what I want done.

For instance user A wants to search for users within 100 miles of his zipcode 90210, how can I accomplish this? There must be a database out there that I compare to or something ? Alternatively I wouldn't mind searching via city instead of postal code.

I'm sure someone here has some experience with this or can point me the right direction. Any help is much appreciated!

Thanks again,
mike123

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-05-21 : 04:32:05
this could help:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=40295
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81360

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-05-21 : 06:43:34
See also:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Distance+of+Zip,Postcodes

(includes Spirit's links, and some others too)

Kristen
Go to Top of Page

codezilla94
Starting Member

6 Posts

Posted - 2007-11-12 : 20:09:09
(spam removed --graz)
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-11-12 : 21:45:53
It cost $20 and you can get it for free here!
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81360



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -