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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-16 : 00:18:54
|
Russell writes "I want to find out how I can run an sql statement that will find a set of matching zip code range and then sort the results with the closest zip code number displying fisrt.
for example - someone enters zip code 11355. I not only want to return any records with zip codes from 11300 to 11400, but I also want to show the closest one first.
I am using NT4.0 with sql 7.0" |
|
|
|
|
|
SQL order by closest zip code