can't think of a better forum.
I want to implement a more sophisticated UK postcode search on a site
- "LIKE 'NW%'" etc, is not bringing back good enough results.
A feature that would allow me to ask: "give me all outward postcodes
in a 30 mile radius of NW10" would be ideal.
Has anyone had to do this before? - any advice on how much
appreciated. Some of the postcode products available don't really
seem to offer this feature.
NHThanks for the links - I'll follow them up.
NH|||Nazir wrote:
> Hi - I know this isn't really a specific SQL Server question but I
> can't think of a better forum.
> I want to implement a more sophisticated UK postcode search on a site
> - "LIKE 'NW%'" etc, is not bringing back good enough results.
> A feature that would allow me to ask: "give me all outward postcodes
> in a 30 mile radius of NW10" would be ideal.
> Has anyone had to do this before? - any advice on how much
> appreciated. Some of the postcode products available don't really
> seem to offer this feature.
There is a system called Address Point which associates a OS grid ref with
each Delivery point (full post code + street number). This is, I suppose,
how MultiMap works. Whether you could adapt this system just to deal with
the outward portion of the postcode I am not sure.
Kennedy
