Multiple wildcard criteria

[cru]

I am looking to find ways to use wildcard to find a first character (L or E)
and a fifth character (U)...Is this possible?

i.e. I have batch ID: L208U70AA1, need to search by first character (L) then
fifth character (U).

Any assistance is appreciated. Thanks.

 

[Marshall Barton]

I am looking to find ways to use wildcard to find a first character (L or E)
and a fifth character (U)...Is this possible?

i.e. I have batch ID: L208U70AA1, need to search by first character (L) then
fifth character (U).

Try setting the field's criteria to:

Like "L???U*"

or, if you need to search for L or E as the first character:

Like "[LE]???U*"

 

[cru]

Hi Marsh,

This worked great...thank you so much.

CRU

I am looking to find ways to use wildcard to find a first character (L or E)
and a fifth character (U)...Is this possible?

i.e. I have batch ID: L208U70AA1, need to search by first character (L) then
fifth character (U).

Try setting the field's criteria to:

Like "L???U*"

or, if you need to search for L or E as the first character:

Like "[LE]???U*"