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 -> Re: SQL to remove char from string?

Re: SQL to remove char from string?

From: Chris Colclough <chris.colclough_at_jhuapl.edu>
Date: 1998/02/16
Message-ID: <34E84D4D.650D7C00@jhuapl.edu>#1/1

Another method is:

select translate ('(888)555-1212','1234567890()+-_','1234567890')

agaldo_at_repsol.es wrote:

> In article <34C427A2.8A0DFA96_at_ix.netcom.com>,
> Billy <123456781_at_ix.netcom.com> wrote:
>
> > 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.
Received on Mon Feb 16 1998 - 00:00:00 CST

Original text of this message

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