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.
| Author |
Topic |
|
smartlizard
Starting Member
24 Posts |
 Posted - 2002-02-24 : 21:16:03
|
| I have a Table full of Addresses.I have a field name Address, that has the following info in it..."100 S. Kentucky Ave."I want to be able to find all the neighbors on the same street, (actually only want to return 5 neighbors down and 5 neighbors up the street.)Any Ideas for me?Ron Sellhttp://smartLIZARD.com |
|
|
Tigger
Yak Posting Veteran
85 Posts |
Posted - 2002-02-24 : 21:42:03
|
| Can you split the address field into 2 columns - house number, street namethen you would just want records with same street name and where house number between (housenumber - 5) and (housenumber + 5) |
 |
|
|
|
|
|
Finding Neighbors!