Knowledgebase
Selecting multiple categories
A filter in the form "EIN IN ('01223344','023343543'...)" is MUCH more efficient than "EIN='01223344' OR EIN = '023343543'...". One test found that the former approach with a list of 73 EINs took 3 seconds to complete, while the latter took 150 seconds.
This form can be used to select multiple ZIP codes (ZIP5 IN ('20036','20037...)) county FIPS codes, states, NTEE codes, etc.
Working with Wildcards
To select all records with 'CHILD' in the name:
NAME LIKE '%CHILD%'
No comments.
Please login to add your own comments.