Re: like '%'

Of course this method will supress the index. Try using the escape clause:

where field like 'prod 100\%' escape '\'

Of course if you are just looking for anything with %, then you will end up supressing the index anyway with something like this:

where field like '%\%%' escape '\'

>From: "Eric Lansu" <eric.lansu_at_quicknet.nl>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: like '%'
>Date: Thu, 25 May 2000 05:11:16 -0800
>
>Choose some other char that doesn't appear in this field (like # or ~) and
>
>select field from table
>where replace (field,'%','#') like '%#%'
>/
>
>Dirty trick, but it works!
>
>Eric Lansu
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Thursday, 25 May 2000 11:35
>
>
> > Hi group
> >
> > how do i despeciali. % char in like operator?.
> >
> > prod_name
> > =--------
> > prod 100%
> >
> > i want to select all product which contains % as a pattern.
> >
> > TIA
> >
> > **************************************
> > H.Karthikeyan
> > Tata Infotech Ltd.,
> > System Integration Division,
> > 80 Feet Road, Indira Nagar, Bangalore.
> > Ph: (80) 528 4681 (off) Ext: 423
> > E-mail: h.karthikeyan_at_tatainfotech.com
> > **************************************
> >
> > --
> > Author: H. KARTHIKEYAN
> > INET: h.karthikeyan_at_tatainfotech.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>--
>Author: Eric Lansu
> INET: eric.lansu_at_quicknet.nl
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).