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!
--
