A query to match Post Codes to Towns

[KenshiroUK]

Hi again.

I have created a query that seletcs customer data from from an orders table. However one of the main problems I have encountered is that the Post Code is wrong for town/city entered. Now is it possible to write a query that matches first 3 or 4 digits of a postcode and changes the customers town/city to match it in the select query?

 

[pr2-eugin]

So do you have a table that lists all codes and their corresponding cities? Something like..

ID    pCode    City
1    BH1    Bournemouth
2    BS1    Bristol
3    BA1    Bath
5    EX1    Exeter
:
:

 

[KenshiroUK]

So do you have a table that lists all codes and their corresponding cities? Something like..

ID    pCode    City
1    BH1    Bournemouth
2    BS1    Bristol
3    BA1    Bath
5    EX1    Exeter
:
:

Yes I do, its pretty much as you described it