Posted by cluthz on 05/21/07 19:25

>
> As for your list, go see -
> http://www.postcode-ads.co.uk/s/index.htm
>
> Presumably the splitting is a prelude to sorts of all kinds. Unless
> you stick a [space] before any single-digit area (e.g. convert G1 1AA
> to G 1 1AA) you'll have more problems. I suggest you might avoid
> problems in the future by manipulating any new input, adding spaces
> appropriately.


Thanks for input. Actually splitting of postcodes is for searches. We often
need to search people by area and currently the results do not always give
what you want.

for example, if we want people with postcodes W1 and W12, because this
search includes all postcodes beginning with W1, it also returns all the
W11's, W13's, etc.

This is not desirable. It is unlikely we will ever need to search on an
actual full postcode.

Therefore the first part is important. Having it as a single field, we can
search on actual match, rather then the first part.

Sorting of postcodes is not particularly a factor in our application.

Thanks for input

[Back to original message]