Re: a sql question

From: Ranga Chakravarthi <ranga_at_removethis.cfl.rr.com>
Date: Fri, 16 Aug 2002 01:15:49 GMT
Message-ID: <9nY69.195188$s8.3649204@twister.tampabay.rr.com>

select phone_no
from test
where translate(phone_no, '0123456789#', '#') IS NOT NULL

This will give you all the rows with non-numeric phone_no

"Joe Bayer" <u705413818_at_spawnkill.ip-mobilphone.net> wrote in message news: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 - 20:15:49 CDT