Page 1 of 1
filter to dial only certain area codes
Posted:
Thu Jan 18, 2007 4:54 pmby kchung
How can I filter the leads to dial only specific area codes?
I tried:
- Code: Select all
'LEFT(phone_number, 3)' = 'XXX' and
'LEFT(phone_number, 3)' = 'YYY' and
...
...
'LEFT(phone_number, 3)' = 'ZZZ'
Substitute the letters for your favorite area codes you wanna call.
It doesn't seem to work. [/i]
Posted:
Thu Jan 18, 2007 5:17 pmby mflorell
Have you tried adding this filter to the campaign:
phone_number LIKE "312%"
Posted:
Fri Jan 19, 2007 1:36 amby palito
Also, use "OR" instead of "AND", as in:
phone_number LIKE "XXX%" OR
phone_number LIKE "YYY%" OR
...
...
phone_number LIKE "ZZZ%"
Posted:
Wed Jan 24, 2007 7:32 pmby kchung
Thanks everyone, i'll give it a try.
doubt
Posted:
Thu Jan 25, 2007 11:25 amby devafree
Will a filter like phone like 'xxx%' dial out the leads matching
or would it not dial out the matching leads, i.e filter out those leads?
devafree
Posted:
Thu Jan 25, 2007 12:43 pmby palito
I understand that the filters refers to whatever you'd place after the WHERE in the SQL clause. Therefore, what you write in for the filter, is what will be selected. If you want to filter out, you can use NOT, as in phone_number NOT LIKE "XXX%".
There are plenty of good SQL tutorials you can look into as well, those will give you more ideas.
Regards