Try using escape clause:
select field from table
where field like '%\%%' escape '\';
HTP.
Gunawan Yuwono
- Eric Lansu <eric.lansu_at_quicknet.nl> wrote:
> 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).
Received on Thu May 25 2000 - 08:40:36 CDT