Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> a kinder gentler LIKE

a kinder gentler LIKE

From: pretzelman <pretzelman_at_fakeaddress.com>
Date: 2000/07/27
Message-ID: <B0A55195D3D4B294.3FBA51833427F821.162B86F9A16323EF@lp.airnews.net>#1/1 






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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US