Re: An urgent Sql question Please help !

From: Kalpana Vora <kvora_at_us.oracle.com>
Date: Thu, 22 Oct 1998 16:11:10 -0700
Message-ID: <362FBB8E.7436F606@us.oracle.com>

Hey,

I hope this helps...

select translate(col1,

                         '1234567890abcdefghijklmnopqurstuvwxyz',
                         '1234567890')

from Table1;
 This query will not return rows where col1 has only characters.

• Kalpana

MUJAHID HAMID wrote:

> Dear All.
>
> I want to remove characters from a column when I select from it but keep
> numbers from it
> e.g. Table1:
> col1
> ====
> 1234
> 123a
> 12b4
> ab34
> I would like to select all the rows from this table but with characters
> filtered out.
> I like to get the following result from the query
>
> col1
> ====
> 1234
> 123
> 124
> 34
>
> and if possible just select the rows with number only and no characters in
> it.
>
> With Thanks in advance
>
> Mujahid_at_pharmco.demon.co.uk

Received on Thu Oct 22 1998 - 18:11:10 CDT