Re: Dumb newbie question; how to identify numerics.

From: Martin Burbridge <pobox002_at_bebub.com>
Date: Fri, 31 Jan 2003 00:36:14 GMT
Message-ID: <Xns9313C6F639527pobox002bebubcom@216.148.227.77>

jaywalk_at_techie.com (Jaywalk) wrote in
news:8f27f83a.0301301031.5804c48b_at_posting.google.com:

> This is embarassing. I can't for the life of me remember how to get a
> query to return results only when a certain VARCHAR2 field is not
> numeric. Some of the fields are numeric and some are not, but I can't
> do something like "to_number(fieldname)" to figure out which ones are
> numeric because it blows up on the first non-numeric.
>
> I've been through the manuals, FAQs and past posts and I'm still
> coming up blank. Is there a kind soul out there who can help me past
> this brain cramp I'm having?
>
> Any help would be appreciated.
>
> Jaywalk

Look at this link:

(URL may wrap)

http://groups.google.com/groups?&selm=Xns927AD545426D9pobox002bebubcom% 40216.148.227.77

Hth
Martin Received on Thu Jan 30 2003 - 18:36:14 CST