Thanks Malcolm and John. but as Bob said, they let anything through.
Bob,
I was hoping for a non-VBA solution to this, although I will try out the regular expressions code you gave me because I need to start learning that. What I'm doing is......well, first let me start by stating that I'm new to Access development and I haven't done much Database development. Okay, that being said, what I'm doing is I created a small Access database that links (appropriate) tables from our main SQL database to perform some simple queries. The queries look at a text field and part of my criteria was what I asked in the first post. Instead of placing the same text inside all the queries, I decided to put them in a table called tCriteria. All the queries now refer to that one table for easy modification. As I was building the table, this question came up. That's basically why I'm not looking for a VBA solution. Is there a non-VBA solution to this?
Thanks