Brick Codes
From: Shaun <nospam_at_nospam.com>
Date: Tue, 17 Feb 2004 09:02:29 -0000
Message-ID: <4LkYb.4629$h44.733074_at_stones.force9.net>
Hi,
Date: Tue, 17 Feb 2004 09:02:29 -0000
Message-ID: <4LkYb.4629$h44.733074_at_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 - 10:02:29 CET