how to pull anything NOT a number or character?

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

I have a string of numbers/letters

It has to be 6 characters/numbers long.

I need to find all records that either dont have a number
or character(/ . ,) and records that are under 6
characters/digits

the following would be ok

a1d222 but the next would be wrong
124g-k cant have a dash

any help would be great
scott
 
In query design view, you might set the criteria on your field to something
like this:

Like "*[!0-9a-z/.,]*" Or Not Like "??????"
 
Back
Top