Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!news.tu-darmstadt.de!fu-berlin.de!uni-berlin.de!move.willo.nunet.NET!not-for-mail
From: "Hulk" <HulknoooSpam@unitywars.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Querying for Strings with containing Wildcards
Date: Mon, 11 Nov 2002 15:50:30 -0600
Lines: 47
Message-ID: <aqp8r3$c8v6p$1@ID-68406.news.dfncis.de>
References: <aqp14b$c9k02$1@ID-68406.news.dfncis.de> <3DD019EB.56E595F4@exesolutions.com>
NNTP-Posting-Host: move.willo.nunet.net (199.249.168.50)
X-Trace: fu-berlin.de 1037051555 12877017 199.249.168.50 (16 [68406])
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:89227
X-Received-Date: Mon, 11 Nov 2002 14:52:21 MST (news.easynews.com)


where instr(field,chr(37)) > 1;

;-D  Works at any rate .... thanks much


"Daniel Morgan" <dmorgan@exesolutions.com> wrote in message
news:3DD019EB.56E595F4@exesolutions.com...
> Hulk wrote:
>
> > Hey guys,
> >
> > I was wondering if I could get a hint on querying for strings containing
a
> > wildcard, notable the % sign.  Against our advice one our clients has
> > created many values in their database containing percent signs and would
now
> > like a list of the appropriate records so they can delete them.
> >
> > Obviously the following does not work,
> >
> > select field from table where field = 'xx%'
> >
> > I tried the following
> >
> > set escape \
> >
> > select field from table
> >
> > where field = 'xx\%';
> >
> > This kinda worked excpet it does not seem to allow us to search for any
and
> > all records containing a percent sign.
> >
> > Any tips of advice would be appreciated.
>
> Try the following SQL
>
> select ascii('%') from dual;
>
> I think it will lead you in a direction that will work.
>
> Daniel Morgan
>