Thank you, Bill & Razzak. Will do...
Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: November-11-13 1:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Search for wildcards At 12:57 PM 11/11/2013, Stephen Markson 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. Stepehen, This is NOT a bug. You cannot use wild card character, such as "%" with CONTAINS when your connected database wild card (MANY) setting is also set to "%". SHOW CHARACTERS at the R> prompt will display the character settings, including the settings for BLANK, DELIMIT, LINEEND, SEMI, QUOTES, PLUS, SINGLE, MANY, and IDQUOTES. In your specific scenario, follow the eloquent solution provided by Bill Downall in his earlier reply. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
