Re: How to search for %

From: Amr Hambazaza <AHambazaza_at_memc.com>
Date: Wed, 18 Oct 2000 15:00:04 -0500
Message-Id: <10653.119708@fatcity.com>

Try

select * from test where a like '\%' escape '\'

Hope this helps,
Amr

                                                                                                                   
                    <ORACLE-L_at_fat                                                                                  
                    city.com> AT         To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> AT    
                    MEMCPSMTP            MEMCPSMTP_at_MEMCMail                                                        
                                         cc:     (bcc: Amr Hambazaza/MIS/SW/MEMC)                                  
                    10/18/00             Subject:     How to search for %                                          
                    12:20 PM                                                                                       
                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   
                                                                                                                   

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