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...
 
Back
Top