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

Reply via email to