Aristotle Support

Records by Zip Code

Article ID: 742
Last updated: 07 Mar, 2010

Records by Zip Code

All records within a particular zip code or zip codes.

 

 

Join

And

Table

Addresses

Field

Zip Code

Relationship

Starts With

Value

92101

Sub-Query Join

OR

Field

Zip Code

Relationship

Start With

Value

92102

 

*You will notice that the relationship is starts with. Since our database does standardization automatically, most zip codes will be Zip+4. If we had picked exactly matches, the zip codes with the additional +4 would have been excluded.

This article was:   Helpful | Not helpful Report an issue


Article ID: 742
Last updated: 07 Mar, 2010
Revision: 1
Views: 419
Prev     Next
Records by Street       Records with Last Year's code