Re: Zip codes...

[Dan Nelson]

In the last episode (Feb 24), Roy Nasser said:
> Hello,
> 
> I am from Brasil (As many may know... :)) and i want to do some sql stuff
> with Zipcodes...
> 
> I think that it is acceptable due to the way that the postal system works
> here to use the numbers closest...i.e.

If you mean closest in the mathematical sense, 

SELECT zipcode FROM table ORDER BY ABS(zipcode-$myzip)

will work.  If you want true geographic locality, you'll have to store
X + Y coordinates for each zipcode or something similar, and order by
abs(zipx-my_x) * abs(zipy*my_y) .

-- 
	Dan Nelson
	dnelson@stripped