View Single Post
  #2 (permalink)  
Old March 9th, 2004, 05:36 PM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

In your query's criteria section for that field, enter this as the criteria:

Like "*(?)"
Like "*(??)"

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 ().



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote