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 -> Need SQL number conversion

Need SQL number conversion

From: Randy Harris <randy.harris_at_nospam.net>
Date: Sun, 13 Apr 2003 22:52:13 GMT
Message-ID: <xSlma.11$qa5.27539@newssvr28.news.prodigy.com>


I need to find the max numeric value in a field that contains some non numeric data, such as

31528
63595
X2187
77141
35-28

records with non numeric data can be ignored.

I've tried:

SELECT MAX(TO_NUMBER(SerialNumber)) FROM XYZ.COUPON;

but the TO_Number stumbles on the non numeric data.

I would grateful for any help.

--
Randy Harris
Received on Sun Apr 13 2003 - 17:52:13 CDT

Original text of this message

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