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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php