Re: Help on Oracle Wildcards

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/05/07
Message-ID: <3371f98a.23993100@newshost>#1/1

On 7 May 1997 14:25:21 -0700, surendra_at_virgo.tcs.com (Surendra Naidu) wrote:

>I am having a problem in using the LIKE clause. I would like
>to use "_" as a character rather than as a wildcard. Is there
>any way of doing it. \ doesn't seem to work and "set escape"
>is used for some other purpose.
>

select * from T where f like '\_%' escape '\';

Will do it....

>------------------------------------------------------------------------
>Surendra Naidu |
>TCSI Corporation, Alameda CA | INTERNET: surendra_at_tcsi.com
>------------------------------------------------------------------------

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed May 07 1997 - 00:00:00 CDT