Re: How to search for %

From: Documentazione Tecnica <dadostecnicos_at_hotmail.com>
Date: Thu, 19 Oct 2000 17:11:57 CEST
Message-Id: <10654.119785@fatcity.com>

Jhon,
Try this

select * from test where a like '[%]'
Bye
Stefania

>From: "Shaw, John B" <jbshaw_at_ingr.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: How to search for %
>Date: Wed, 18 Oct 2000 12:20:31 -0800
>
>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).

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Wed Dec 31 1969 - 17:59:59 CST