AnsweredAssumed Answered

Postcode Field Characters

Question asked by andyg4137 on Apr 30, 2009
Latest reply on Apr 30, 2009 by Orlando


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