On Fri, 22 Feb 2008 12:50:42 -0600 Barbara Duprey <[EMAIL PROTECTED]> dijo:
> > 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? > I think you just need LIKE, but using a leading wildcard (*) before your > search string, and probably after as well. For instance, I have queries > that look for a given month anywhere in a field with LIKE '*01/*' to > select any record that has the characters 01/ in it. Barbara, That solved the problem. I tried wildcards but they didn't work. However, after reading what you said I tried again. It turns out that the wildcards do work if they are _inside_ the single quotes, e.g., LIKE '*stringvalue*'. I had them outside the single quotes. That leads me to another issue - what if the string that I am selecting on contains a ? or a *? Thanks! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
