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=
