Brick Codes

From: Shaun <nospam_at_nospam.com>
Date: Tue, 17 Feb 2004 09:02:29 -0000
Message-ID: <4LkYb.4629$h44.733074@stones.force9.net>

Hi,

Using mySQL I have a table of Locations around the country. My system produces reports based on these Locations. I also have a table containing Brick Codes e.g.

Brick Post Code
AB51 AB51
AB52 AB52
AB55 AB55
AB56 AB56
AL01 AL1
AL02 AL2
AL03 AL3
AL04 AL4

How can I compare the first 3 or 4 letters of the postcode in the Locations table to the corresponding entry in the Brick Codes table so I can add it to my report?

Thanks for your help Received on Tue Feb 17 2004 - 03:02:29 CST