recognize alpha's in varchar field of numeric characters

From: md <>
Date: Fri, 28 Mar 2008 08:07:56 -0700 (PDT)
Message-ID: <>

I want to recognize alpha values buried in varchar fields.

5555X5555 = hit
5555555 = no hit

select * from table where to_number(field) is not null;

Doesn't work. Was counting on to_number to fail if it hit an alpha, which it does, but the
query dies too. Any ideas? Can do with simple sql? Received on Fri Mar 28 2008 - 10:07:56 CDT

Original text of this message