Re: Select non nummeric values

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/31
Message-ID: <39858087.2D33@yahoo.com>#1/1

Johann Michael wrote:
>
> Hello,
>
> how can I select all rows with non nummeric values in an char column?
>
> --
> CU JM
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> = Write me @ JohannM_at_writeme.com
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

something along the lines of

where replace(translate('0123456798','@@@@@@@@@@@'),'@',null) is not null

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Mon Jul 31 2000 - 00:00:00 CDT