Postal code filter

[hansg]

Hi,

I am trying to use a filter to dial specific postal codes. The postal codes are UK format which start with usually 2 letters followed by 1 or 2 numbers
Example BA14 7HP

I am trying to filter so that the system only calls for example BA10 XXX, BA11 XXX and BA12 XXX

I have succesfully used filter to just BA10 by using:

Code: Select all

postal_code LIKE "BA10%"

I have tried

Code: Select all

postal_code LIKE "BA10%" AND
postal_code LIKE "BA11%" AND
postal_code LIKE "BA12%"

When I apply that all of the leads are removed from the hopper and dialable leads.

What is it I am doing wrong when trying to apply multiple together?

[carpenox]

try: postal_code like ('BA10%','BA11%','BA12%')

or "in" instead of "like"

[hansg]

Those options you gave me didn't work but I managed to get it working by using

postal_code LIKE 'BA10%' OR
postal_code LIKE 'BA11%' OR
postal_code LIKE 'BA12%'

[carpenox]

nice, good post back