Creating a new filter

[daredevilbear]

Hello,

I am new to vicidail and i am trying to create a new filter the only uses numbers from chicago, IL. Right now the filter i am using is "postal_code in ('60601','60602','60603','60604','60605','60606','60607','60608','60609','60610','60611','60612','60613','60614','60615','60616','60617','60618','60619','60620','60621','60622','60623','60624','60625','60626','60627','60628','60629','60630','60631','60632','60633','60634','60635','60636','60637','60638','60639','60640','60641','60642','60643','60644','60645','60646','60647','60648','60649','60650','60651','60652','60653','60654','60655','60656','60657','60658','60659','60660','60661','60662','60663','60664','60665','60666','60667','60668','60669','60670','60671','60672','60673','60674','60675','60676','60677','60678','60679','60680','60681','60682','60683','60684','60685','60686','60687','60688','60689','60690','60691','60692','60693','60694','60695','60696','60697','60698','60699','60701','60707','60803','60804','60805','60827')" which works but i was looking for a more efficient way to do this.

thank you

[daredevilbear]

would it be:

city LIKE "CHICAGO"

thanks

[williamconley]

if you actually have the city field populated with the word chicago all upper case it would be:

city in ('CHICAGO')

this allows adding more cities with a simple addition later: city in ('CHICAGO','ANAHEIM')

but if you want to be cute:

upper(city) in ('CHICAGO') will not care if chicago is upper case or not (it will convert it to upper).

you could also use:

upper(city) like 'CHIC%'

which will catch any cities starting with chic (case insensitive), but not allow for easy addition of other cities.

happy hunting.

[daredevilbear]

okay thank you for the response!