View Single Post
 
Old September 15th, 2003, 11:54 AM
jepley jepley is offline
Registered User
 
Join Date: Sep 2003
Location: Fredericksburg, VA, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Numeric Check in Query

I have a field that is defined as varchar2(25) but mostly contains numeric values. A report that I am creating needs to ignore records that contain non-numeric values, and then sum the records where the values are numeric. Sample data is like:

district services
-------- ---------
GA 45
HA 13
NN meter
HM 32

The desired output would be:

sum(services)
-------------
90

Any suggestions would be appreciated.