Re: like '%'

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).
  

  ---