AnsweredAssumed Answered

Postcode Field Characters

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

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

 

 

Outcomes