Postcode Field Characters
i'm tryingto setup a field which picks up the initial postcode area but nothing else eg: BH, SO, GL so that i can run a report on number of customers in each area.
The problem occures with single letter postcodes such as E,W,S,B etc.
i have solved this once in the past but for the life of me i cannot remember how to do it although i think i used trim.
help appreciated as always