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 -> Re: finding rows matching pattern

Re: finding rows matching pattern

From: Ronald Fischer <ronaldf_at_eml.cc>
Date: 26 Aug 2003 07:47:36 -0700
Message-ID: <219750c.0308260647.1b7cf429@posting.google.com>


Harald Maier <maierh_at_myself.com> wrote in message news:<m38ypgoh9z.fsf_at_ate.maierh>...
> ronaldf_at_eml.cc (Ronald Fischer) writes:
>
> > 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?

> You may try the translate function.

Thank you, that worked. Received on Tue Aug 26 2003 - 09:47:36 CDT

Original text of this message

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