In your query's criteria section for that field, enter this as the criteria:
The first one gives you any one-digit number. The second gives you any two-digit number, etc. Remember to include the word LIKE in your criteria. It's a key word.
The * wildcard signifies that anything can be before the (.
The ? wildcard(s) signifies that one (two, etc.) characters can be inside the ().
Michigan Dept. of Environmental Quality, Air Quality Division