Wildcard characters

[cervantes008]

Hi,

I am trying to figure out in a wildcard query distinctive part numbers.


I have part numbers that are similar to these:

Part numbers with US prefix
USUSE123
USUSE-123

Part numbers that have no prefix
USE123
USE-123

US is the prefix that I am trying to query. Unfortunately there are part numbers that also contain the same US as part of their part number.

Part numbers will always begin 3 alpha digits then numbers, unless of course it is paired with a 2 digit (US) pre-prefix.

I tried creating the criteria as Like "US???*", but that brings up all part numbers with US at the beginning. I also tried Like "US@@@*" but that didn't pull up any items. I can't think of any other criteria.

 

[John Big Booty]

If the part numbers that have the US prefix always have a 5 character Alpha prefix the following should work as criteria;

Left([YourPartNum],2)="US" And Mid([YourPartNum],5,1) Like "*[A-Z]*"

 

[cervantes008]

WORKS!!!!!! Thank you!!!! SOLVED!!