Re: An urgent Sql question Please help !

Try Translate the characters to space then ltrim and rtrim them. Eg.
select ltrim(rtrim(translate(upper(col),'ABCDEFGHIJKLMNOPQRSTUVWXYZ',' '))) from table

Keith Lim

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 29 1998 - 17:51:25 CST