Stephen, Temporarily change your "many" character:
SET MANY='*' SELECT colname FROM tableview WHERE colname CONTAINS '%' SET MANY='%' Bill On Mon, Nov 11, 2013 at 12:57 PM, Stephen Markson <[email protected]> wrote: > Hello, > > Sorry if this is a dumb question. > > How do I search for a wildcard character in text? Both of the following > queries return every row: > SELECT colname FROM tableview WHERE colname CONTAINS '%' > SELECT colname FROM tableview WHERE colname CONTAINS (CHAR(37)) > > I can use the following query, but surely there's a simpler way: > SELECT colname FROM tableview WHERE colname<>(SRPL(colname,'%','x',0)) > > Is this a bug? Can you use wildcards with CONTAINS? I can't find anything > in the documentation. > > > > Regards, > > Stephen Markson > The Pharmacy Examining Board of Canada > 416.979.2431 x251 > > --- RBASE-L > =======================3D======================3 > D= > TO POST A MESSAGE TO ALL MEMBERS: > Send a plain text email to [email protected] > > (Don't use any of these words as your Subject: > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > =======================3D======================3 > D= > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: INTRO > =======================3D======================3 > D= > TO UNSUBSCRIBE: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: UNSUBSCRIBE > =======================3D======================3 > D= > TO SEARCH ARCHIVES: > Send a plain text email to [email protected] > In the message SUBJECT, put just one word: SEARCH-n > (where n is the number of days). In the message body, > place any > text to search for. > =======================3D======================3 > D= > > >
