Re: a kinder gentler LIKE

Oracle and SQL in general doesn't support regular expressions. You could trick this a bit by using
replace(<column>,'0123456789','@@@@@@@@@@') like '@%' but that will definitely not use an index

Hth,

Sybrand Bakker, Oracle DBA

"pretzelman" <pretzelman_at_fakeaddress.com> wrote in message news:B0A55195D3D4B294.3FBA51833427F821.162B86F9A16323EF_at_lp.airnews.net...
> Hello,
>
> Does anyone know how Oracle allows you to specify a pattern such as
> this:
> LIKE '[0-9]%'
> I am trying to get all values which begin with a numeric digit, followed
> by any number of characters of anything else. Oracle doesn't like this;
> IE it doesn't give me the rows I know are there. Thanks.
>
> Paul
>
Received on Thu Jul 27 2000 - 00:00:00 CDT