RE: How to search for %

From: Shaw, Glen <Glen.Shaw_at_BellSouth.com>
Date: Wed, 18 Oct 2000 16:16:00 -0400
Message-Id: <10653.119711@fatcity.com>

John,

Another alternative might be: select * from test where instr(a,'%') > 0

Regards,
Glen

-----Original Message-----

From: Gogala, Mladen [mailto:MGogala_at_oxhp.com] Sent: Wednesday, October 18, 2000 4:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to search for %

Hopefully , this will answer your question:

ADM-MGOGALA>select * from a;

A
--

aC
bC
cC
5C
%C

ADM-MGOGALA>select * from a where a like '\%%' escape '\';

A
--

%C

-----Original Message-----

Sent: Wednesday, October 18, 2000 4:21 PM To: Multiple recipients of list ORACLE-L

I need to find a '%' in char field (8.05) and I can't seem to figure out the right sql to get it - the following are what I've tried so far (\ is the escape).

SQL> select * from test where a like '\%'; A

ab%cd
abcd
efgab

SQL> select * from test where a like '%\%%'; A

ab%cd
abcd
efgab

SQL> select * from test where a like '%\%'; A

ab%cd
abcd
efgab

SQL> select * from test where a like '\%%'; A

ab%cd
abcd
efgab

.... . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. John B. Shaw
Intergraph Public Safety
mailstop LR24A4
jbshaw_at_ingr.com
256-730-8038
All the usual disclaimers and some of the certifications
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Shaw, John B
INET: jbshaw_at_ingr.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Gogala, Mladen
INET: MGogala_at_oxhp.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