Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Querying for Strings with containing Wildcards
where instr(field,chr(37)) > 1;
;-D Works at any rate .... thanks much
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3DD019EB.56E595F4_at_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
>
Received on Mon Nov 11 2002 - 15:50:30 CST