Re: Select non nummeric values

From: Johann Michael <JohannM_at_writeme.com>
Date: 2000/08/02
Message-ID: <8m8rak$fjk$1@nnrp1.deja.com>#1/1

perfect! thx

>
> 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
>

--
CU JM
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 = Write me @ JohannM_at_writeme.com
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Wed Aug 02 2000 - 00:00:00 CDT