Re: Dropping non alphanumeric characters

Hi,

You can use the TRANSLATE function like this:

select translate('1a231b3c','123abc','123') from dual;

TRANS

Of course you have to build it out according to your needs.

Regards,

Michael Ringbo, DDE A/S

Nimrod Oren wrote:

> Does anybody have an idea how can I drop non alphanumeric charachters
> from a varchar2 variable?
Received on Mon May 25 1998 - 15:27:50 CEST