Posted by --CELKO-- on 11/15/06 17:30

>>Does anyone know the SQL statement for calculating surrounding suburbs, or can point me in the right direction? <<

I do not know the Australian postal code system, but in the US, we can
get tables of Zones for all the ZIP code (our postal code system).
Zips in Zone 1 are closest, and Zone 9 is the furhterest away The Zones
are used for computing shipping charge. I assume that you have
something like that.

• Next in forum: Re: SLOW performance on table with image fields (SQL 2000)
• Prev in forum: Re: General advice needed regarding MS Access, MS SQL Server, MySQL/PostgreSQL
• Thread view: Re: SQL to calculate surrounding suburbs

[Reply to this message]