Re: How to search for %

From: <Winnie_Liu_at_infonet.com>
Date: Wed, 18 Oct 2000 13:37:55 -0700
Message-Id: <10653.119713@fatcity.com>

Your second option works for me!

13:37:53 WLIU(VENUS @apollo) > select * From temp;

ab%cd
abcd
efgab

3 rows selected.

13:38:04 WLIU(VENUS @apollo) > select * From temp where a like '%\%%' escape '\';

ab%cd

1 row selected.

Winnie

"Shaw, John B" <jbshaw_at_ingr.com>@fatcity.com on 10/18/2000 01:20:31 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: How to search for %

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 Received on Wed Oct 18 2000 - 15:37:55 CDT