RE: like '%'

From: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk>
Date: Thu, 25 May 2000 18:25:45 +0500
Message-Id: <10508.106665@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]

		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>

> 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
Received on Thu May 25 2000 - 08:25:45 CDT