Oops. should've been translate(phone_no, '#0123456789', '#')
"Ranga Chakravarthi" <ranga_at_removethis.cfl.rr.com> wrote in message
news:9nY69.195188$s8.3649204_at_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:21:53 CDT
