Working with Postcodes in Advanced Find to create a Marketing List RRS feed

  • Question

  • 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.

    Friday, November 15, 2013 12:11 PM