I have a field I use for selecting records in a database of test questions by placing unique strings in the field. For example, I might enter "FE1a-001" which means that it will be merged into Final Exam 1a and will be question #1. This works well, but sometimes I need to merge the same question into other documents. For example, if I want the same question to appear in Final Exam 3c as question #30 I need to enter "FE3c-030" in this field as well.
I can add both values in the field, but then the select queries do not pick up the record at all. I need the LIKE operator to function as long as the string occurs *anywhere* in the field, not that the field be *the same as* the string. I tried adding a new field, but Base informed me that if I did so it would delete all the data in the table! I need to get the project delivered to the customer by Monday morning so I'm getting desperate for a solution. The Help file has nothing about how the syntax is supposed to work. Are there other operators besides LIKE? If so, what are they, and how do they work? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
