Can you use a WHERE IN statement in a custom filter?
Where [zip] in ("12345", "98765", "65432")
Or, is there another statement in the custom filter to accomplish the above without joining multiple filters?
The custom filter syntax doesn't require the "where". This is the expression:
[ZIP] in ("12345","98765","65432")
Tools where you can enter custom expressions (ex: Filter, Formula, Multi-Field Formula, Multi-Row Formula) also feature a list of functions that can be used for reference or double-clicked to insert. The expression used in this case is found in the "Operators" section.
Thanks. I wonder if there is a list of common custom filter syntaxes? Or, is it just SQL with Select and Where?
Just to add, if the field you're filtering is numeric (rather than string), you do not need the quotes. [Account Number] in (123,456,798).
