Brick Codes
| From: | Shaun | Date: | Mon, 16 Feb 2004 22:45:51 +0000 |
| Subject: | Brick Codes | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32967@lists.php.net to get a copy of this message | ||
Hi,
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