RE: like '%'

From: Larry G. Elkins <elkinsl_at_flash.net>
Date: Thu, 25 May 2000 07:09:17 -0500
Message-Id: <10508.106651@fatcity.com>

select *
from products
where prod_name like '%\%%' escape '\'

The above uses the escape clause to specify an "escape" character of \. The use of the escape character in front of the second % causes it to be treated as a literal value, not a wildcard.

You can find more detailed info on this in the LIKE operator section of the SQL manual.

Regards,

Larry G. Elkins
The Elkins Organization Inc.
elkinsl_at_flash.net
214.954.1781

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of H. KARTHIKEYAN
Sent: Thursday, May 25, 2000 4:35 AM
To: Multiple recipients of list ORACLE-L Subject: like '%'

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. Received on Thu May 25 2000 - 07:09:17 CDT