Make Table Query to Exclude Particular Zip Code

[Guest]

Zip Code field uses 00000\-9999;0;_ as the input mask. What code would I
need to type in the criteria field to return a table which excludes all
records within a five-digit +4-digit zip code? By using the <> with a
five-digit zip code only, it works correctly; however, the make table query
still returns all records with the 5 + 4-digit zip code.
Any help would be appreciated.

 

[Guest]

You are probably typing the criteria entry like this --- 23456-0123 but you
need to omit the dash as it is not stored in the field.

 

[[MVP] S.Clark]

Select * from tablename where left$(zipcode,5) <> "12345"