Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> An urgent Sql question help Please !

An urgent Sql question help Please !

From: MUJAHID HAMID <mujahid_at_pharmco.demon.co.uk>
Date: Thu, 22 Oct 1998 11:07:15 +0100
Message-ID: <909096223.7978.1.nnrp-02.c2de4f17@news.demon.co.uk>


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 - 05:07:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US