Creating a search query to for letter and numeric values.

[jays35]

From the sample data below, I want to have the query returns only the bottom three records (there are several thousand records similar to the sample below). Currently I have the criteria set to LIKE "U2*" and I would like for it to also return anything with a number "2" followed by a letter and say not the top three records. Thanks in advance!

Dave


120045
251478
021478
U213
U245
2S07-DD

 

[SkipVought]

Hi,

Where left([field name],2) between '2A' and '2Z'

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[jays35]

How would I do this from the query builder?