Help: a sql question

From: Joe Bayer <u705413818_at_spawnkill.ip-mobilphone.net>
Date: Thu, 15 Aug 2002 19:39:45 GMT
Message-ID: <l.1029440386.1122680664@[64.94.198.252]>

Guy,

We have a table, col1 is varchar2

SQL> select * from test;

phone_no

---

2158983309
4125689834
301A3458793
718834T4325

How can I find those bad records which contains non unmber?  

-- 
Sent by joebayerii from  hotmail  within area  com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new

Received on Thu Aug 15 2002 - 14:39:45 CDT