RE: like '%'

Even better:

	SELECT field
	FROM   table
	WHERE  field LIKE '%\%%' ESCAPE '\';

Will do exactly what you want.

Kevin

+-----------------------------------------------------------+
| ktoepke_at_cms.cendant.com                                   |
| Phone: 614/652-5117                                       |
| Fax  : 614/652-5401                                       |
+-----------------------------------------------------------+

-----Original Message-----
From: Eric Lansu [mailto:eric.lansu_at_quicknet.nl] Sent: Thursday, May 25, 2000 9:11 AM
To: Multiple recipients of list ORACLE-L Subject: Re: like '%'

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