Pattern Matching In Access 2010

[Mike Henderson]

I have a column REQ_LOCATION that is 5 Characters in length, either of those can be alpha or numeric. I would like to match the first 4 characters and the the fifth could be any value.

Example of what I would like to return

REQ_LOCATION
MSCD1
MSCD2
MSCD3
A12CA
A12CB
20411


20412
20418

There are 1000s of record so any pattern matching or req expression would be great, VBA would be okay also.

Thanks in advance

[pbaldy]

If you mean what I think, in a query a criteria of:

Like "MSCD*"

would return all the MSCD values.