Re: Boolean Function in SQL

huiming_at_my-deja.com wrote:
>
> >
> > select
> > decode(
> > replace(
> > translate(col,'0123456789','@@@@@@@@@@'),
> > '@',null),
> > null,'IS A NUMBER',
> > 'IS NOT A NUMBER)
> > from table
> >
>
> Very good idea. However this will not return the correct result when
> column contains something like '1234_at_7@'.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

True - but I'm sure a workable character can be found that the poster can be reasonably confident will not be in his source data...

Cheers
C

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

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