Shaun,

This is untested, but should do the trick.

WHERE Brick = CASE LEN(PostCode)
WHEN 3 THEN STUFF(PostCode,3,0,'0')
ELSE PostCode END

or

WHERE PostCode = CASE SUBSTRING(Brick,3,1)
WHEN '0' THEN STUFF(Brick,3,1,'')
ELSE Brick END


Hope that helps,
Rich


"Shaun" <nospam@nospam.com> wrote in message
news:YLkYb.4630$h44.732918@stones.force9.net...
> 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
>
>