Re: An urgent Sql question help Please !

From: David Griffiths <davidg_at_polyphony.demon.co.uk>
Date: Sat, 24 Oct 1998 19:58:49 +0100
Message-ID: <36322368.45B7049F@polyphony.demon.co.uk>

You could try:

select replace (translate(upper(field1),'ABCDEFGHIJKLMNOPQRSTUVWXYZ',

                                    '                          '), ' ', '')
from table1
where rtrim(translate(field1,'1234567890','          ')) is null

You would have to add in other characters into the alphabet string if you wanted to remove punctuation etc.

MUJAHID HAMID wrote:

> I want to remove characters from a column when I select from it but keep
> numbers from it
> e.g. Table1:
> Mujahid_at_pharmco.demon.co.uk
Received on Sat Oct 24 1998 - 13:58:49 CDT