Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Boolean Function in SQL
>
> 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.
Received on Fri Oct 06 2000 - 03:47:48 CDT