Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Filtering for only numbers in a varchar2 field
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