Re: SQL to remove char from string?

From: Tina Tran <tinat_at_sonica.com>
Date: 1998/01/20
Message-ID: <01bd25f3$2b41b8d0$2aaeb6cc@dino>#1/1

Use translate function!

select
translate('Put-your-string-here','01234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ()+-* @!#$%^&-_=|\/?','0123456789') from dual;

Billy <123456781_at_ix.netcom.com> wrote in article <34C427A2.8A0DFA96_at_ix.netcom.com>...
> Hi Everybody!
>
> I need to remove all characters from a string like (888)555-1212 and
> just leave the numbers 8885551212. Some strings could have + signs or
> other stuff like @, klondike 999-1111. I just want to remove any
> non-numeric characters.
>
> Please help. I'm only 12.
>
> Thanks,
> Billy
>
>
Received on Tue Jan 20 1998 - 00:00:00 CST