Tricky Wildcard

[cru]

I am looking to find ways to use wildcard to find a first character (E)
and a fifth character (U)...the tricky part is five number sequence after
the U must be numerical. Is this possible?

i.e. I have batch ID: E208U75432, need to search by first character (E) then
fifth character (U) preceeded by five numerical character.

I have like E%%%%U but not sure how to set a criteria to say next fifth
character must be numerical.

Any assistance is appreciated. Thanks.

 

[Michel Walsh]

Have you tried [0-9] repeated five times in all:


E%%%%U[0-9][0-9][0-9][0-9][0-9]



Vanderghast, Access MVP

 

[John W. Vinson]

i.e. I have batch ID: E208U75432, need to search by first character (E) then
fifth character (U) preceeded by five numerical character.

LIKE "E???U#####" will work in Access; ? matches any single character, and #
matches any numeric digit. The % wildcard is for SQL/Server syntax and refers
to any number of characters and is not a wildcard in Access/JET.