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

Home -> Community -> Mailing Lists -> Oracle-L -> Pattern maching question

Pattern maching question

From: Glenn Travis <Glenn.Travis_at_wcom.com>
Date: Mon, 18 Sep 2000 17:39:10 -0400
Message-Id: <10623.117289@fatcity.com>


How can I get all the contacts which start with numbers? PLEASE NOTE: contact_name is a character field.

select contact_name from contact
where contact_name like '[0-9]%'

does not work (like other dbms...)

My workaround is;

select contact_name from contact
where contact_name < 'A'

but I want to know the proper syntax for the first query. Received on Mon Sep 18 2000 - 16:39:10 CDT

Original text of this message

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