Re: How to search for %

Hi John .

Could you try this query:

SELECT * FROM test WHERE INSTR(a,'%') > 0;

I hope you can receive right result.

Michael Malyk
Cryptologic Inc.
mmalyk_at_cryptologic.com

"Shaw, John B" wrote:

> 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).
Received on Wed Oct 18 2000 - 16:53:45 CDT