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

Home -> Community -> Usenet -> c.d.o.misc -> finding rows matching pattern

finding rows matching pattern

From: Ronald Fischer <ronaldf_at_eml.cc>
Date: 26 Aug 2003 02:25:41 -0700
Message-ID: <219750c.0308260125.1600b161@posting.google.com> 





Say, I have a column C of type varchar. Is it possible using SQL to find 
all rows, where C contains only characters from a specific set - for
example, only digits? That is, a row where C contains '52063' should be 
selected, but a row where C contains '81BF42' should not be selected.



Ronald
Received on Tue Aug 26 2003 - 04:25:41 CDT












Original text of this message













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