Postcode radius searching

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.

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

Postcode Formula Error

Hi,

I want to return everything up to and including, the first letter of the second half of UK postcodes. They take the form "BN2 6DE" or "DN28 7YT". As you can see the first section can be either three or four characters. What I am looking for is a formula that locates the space in the string and then returns the adjacent character and everything preceding and including the space.

The Postcodes are stored in {T_OrderHeader.ShipPostcode}.

I had tried removing the space and returning a set number of digits but this still leaves me with extra data as the first section can be either 3 or four characters.

Please can anyone help? You will be saving me a lot of time manually adjusting entries in Excel!Try this:

Left({T_OrderHeader.ShipPostcode},InStr({T_OrderHeader.ShipPostcode}," ")+1)|||This worked a treat ! thanks very much!