Re: select only numeric values from varchar2 column

Hi, Bruno

This seems to work as long as the non-numeric characters are letters (not puctuation or other non-alpha characters):

...
WHERE UPPER( col1) = LOWER( col1)
...

At least, it seemed to work with some combination alpha, numeric, and alpha-numeric data that I have to work with. No user-defined functions to mess with, either.

Chris

Bruno Decraene wrote:

> I have a table toto with varchar column col1
>
> col1 contains alphanumeric values and numeric values and i want to
> select only the numeric values
>
> How can i do this
>
> Thank you
>
> ansewer to me to rchennaa_at_atos-group.com
>
> Rach
Received on Wed Jul 21 1999 - 14:07:40 CDT