Postcode radius searching

[Nazir]

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.

NH

[Nazir]

Re: Postcode radius searching

Thanks for the links - I'll follow them up.

NH

[Kennedy Fraser]

Re: Postcode radius searching

Nazir wrote:[color=blue]
> 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.
>[/color]

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