Limiting A Query by Using a text format

All,

I have a License_Text_ ID field with several different types of license
formats.

I would like to limit a query to only returning IDs with a format of
"LL#######". Where L=Letter and #=Number. I need the query to only return
those IDs with this exact format.

What can I put in the query Criteria field to accomplish this?

Thanks in advance for your assistance.

Brad

Like "[a-z][a-z]#######"

Rob

"Brad" wrote in message
...
All,

I have a License_Text_ ID field with several different types of license
formats.

I would like to limit a query to only returning IDs with a format of
"LL#######". Where L=Letter and #=Number. I need the query to only return
those IDs with this exact format.

What can I put in the query Criteria field to accomplish this?

Thanks in advance for your assistance.

Brad

Rob,

Works perfect!

Thank you for your help.

Brad

"Rob Parker" wrote in message
...
Like "[a-z][a-z]#######"

Rob

"Brad" wrote in message
...
All,

I have a License_Text_ ID field with several different types of license
formats.

I would like to limit a query to only returning IDs with a format of
"LL#######". Where L=Letter and #=Number. I need the query to only return
those IDs with this exact format.

What can I put in the query Criteria field to accomplish this?

Thanks in advance for your assistance.

Brad