Using wildcard characters in search

[Pete Provencher]

I'm trying to wirte a query that will display a certain text string. I want
to find all the records that one field is formatted in a certain way. I need
to see the records that start with 3 numeric values followed by 2 alpha
characters and then 3 numeric values ie 123AA456. In the criteria cell I
write Like "###??###" . This doesn't work as it displays records where all
the characters in ther field are numeric. Does anyone know how to do what I
need?

Pete Provencher

 

[Pete Provencher]

I figured it out. I used Like "###[a-z][a-z]###"

Pete Provencher