Excluding certain items

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

We have product numbers that are about 12-13 digits long. I An example would
be A45643-10243. There are a small handful that have an R in the seventh
character (i.e. A51243R-10234). I want to exclude all products that have an
R in the seventh from the left spot. How do I do this?

Thanks,
 
Hi,

We have product numbers that are about 12-13 digits long. I An example would
be A45643-10243. There are a small handful that have an R in the seventh
character (i.e. A51243R-10234). I want to exclude all products that have an
R in the seventh from the left spot. How do I do this?

Thanks,
Click to expand...

A criterion of

NOT LIKE "??????R*"

will do it...
 

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

Exclude if last character alpha 8
Need To Exclude Certain Zip Codes 2
Exclude data from field, when another field equals a certain numbe 2
excluding 12:00:00 AM from query results 4
Exclude Records via Join? 4
excluding certain values from a query 5
How to exclude certain records 7
Calculating an Average excluding fields with null values 12

Back
Top