RE: like '%'

From: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk>
Date: Thu, 25 May 2000 18:01:08 +0500
Message-Id: <10508.106659@fatcity.com>

Try

SELECT * FROM tb1 WHERE colm1 like 'S\%%' ESCAPE '\'

In this the first % looks for the character '%' and second % as the wild card
HTH!
ALeem

		-----Original Message-----
		From:	Eric Lansu [mailto:eric.lansu_at_quicknet.nl]
		Sent:	25 May, 2000 6:11 PM
		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).

Received on Thu May 25 2000 - 08:01:08 CDT