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

Home -> Community -> Usenet -> c.d.o.server -> Filtering for only numbers in a varchar2 field

Filtering for only numbers in a varchar2 field

From: Ryan Gaffuri <rkg100_at_erols.com>
Date: 29 Mar 2002 04:54:16 -0800
Message-ID: <6757365f.0203290454.17e9a59d@posting.google.com>


I have a varchar2 field.. I need the first 3 digits(I know I need a substr) to be only numbers so I can do a min(to_number) function on it. My numbers will mainly be in the form 1.1(etc...), but not all.

How do I filter out all other values? Received on Fri Mar 29 2002 - 06:54:16 CST

Original text of this message

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