how to pull anything NOT a number or character?

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
 
B

Brian Camire

In query design view, you might set the criteria on your field to something
like this:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lower-Case Characters 2
Append Invoice 22
Extracting characters 2
Parse text string and insert characters 5
counting characters in a column? 1
Query criteria to see middle 4 characters/12 char field 1
Extracting Characters 4
Numeric to character 3

Top