1 Reply Latest reply on Apr 30, 2009 7:18 AM by Orlando

    Postcode Field Characters

    andyg4137

      Title

      Postcode Field Characters

      Post

      Hi

       

      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 

       

      thanks