Can the wildcard characters (_ %) used in "LIKE" clause be changed
From: Ken Denny <kedenny_at_mail.concentric.net>
Date: 1996/05/04
Message-ID: <318BE81F.48F3_at_mail.concentric.net>#1/1
Date: 1996/05/04
Message-ID: <318BE81F.48F3_at_mail.concentric.net>#1/1
Hello,
I have an application where I allow users to search using wildcard characters.
In my PL/SQL is do an INSTR(<search_value>,'%') and if it's not 0 I use a
select with "WHERE <column> LIKE <search_value>" otherwise I use a select with
a "WHERE <column> = <search_value>". I have no problem with the percent
character (%) but the underscore character (_) occurs in the data and I would
like for it to not be used as a wildcard. For instance I would like to be able
to search for every row where columnx contains an underscore, but if I use
"WHERE COLUMNX LIKE '%_%'" I get every one that contains at least one
character. I there any way to tell Oracle to use a different single character
replacement wildcard?
Thanks
Ken Denny
-- /| / / | / _ _ |< / \ /|/ \ | \ \ / / | \ | \__X___/ | \___Received on Sat May 04 1996 - 00:00:00 CEST