Re: Boolean Function in SQL

From: Haild <haild_0234_at_hotmail.com>
Date: 17 Oct 2000 10:52:05 -0500
Message-ID: <39ec7510$0$26341$45beb828@newscene.com>

plus it is much slower than the other ones that convert to a number and the deal wit hthe execption

In article <8rk3jk$q71$1_at_nnrp1.deja.com>, 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.
Received on Tue Oct 17 2000 - 10:52:05 CDT