I have a large data set that contains leads. I am trying to split the records into marketing lists based on Geographic regions. I am grouping the records by Postcode region.
For instance in my South East region, I build a query where Postcode - Begins with - CT or ME, TN, BN, RH, GU. So far so good - it all works and I can add these to the marketing list.
In my West Midlands area, I encouter the problem of the Birmingham postcode region. Birming Postcodes begin with B and then a number. If I select Postcode - Begins with- B, the query will pull in all of the BN, BH, BB, BR postcodes.
I have determined two possible appraoched current one is to add everything that begins with B and exclude all of the other know regionsthe second is to add where postcode begins, B1,B2,B3 ... B9.
I then also have the issue for S, L, W, N etc.
Either approach works but is long winded.
Is there a clever way to say for example, the field beigns with the letter B and is then followed by a number?
Thanks in advance.
