Is there a way to find all contacts whose postal code (which the person entered on a form) is NOT a five-digit entry? This business only sells in the US.
I am auditing a database that has entries where the person has entered a question (no clue why anyone would do that), or their name instead, or they have a non-US postal code or just plain gibberish.
I need a strategy for finding these erroneous entries. I need to purge them.