Re: fastest "is number" oracle 9i

From: <frank.van.bortel_at_gmail.com>
Date: 14 May 2007 04:13:02 -0700
Message-ID: <1179141182.390605.45800@w5g2000hsg.googlegroups.com>

On 12 mei, 21:05, valigula <valig..._at_gmail.com> wrote:
> HI
> What is the fastest way on returning all the valids numerics from a
> column.
> MAT_CODIGO
>
> these are valids code
>
> IA9903000395
> VD9903300268
> VD9902700081
> VD9904100358
> VC9804105617
> VD9903300267
> VC9903300088
> VC9904101559
> VC9804105613
> VD9902700080
> VD9904100212
> 2000001054007
> VD9904100363
>
> and there are some as:
> VD990410.363
>
> Thanks in advance ...

None of these are valid numbers.
All of these *contain* valid numbers.

What's the exact problem? Lack of normalization (you actually should have
two columns?)? Received on Mon May 14 2007 - 06:13:02 CDT