Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL to remove char from string?
try this : replace(translate('(888)555-1212','(-+)abcd',' '),' ')
Billy wrote in article
> 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.
>
Received on Thu Jan 22 1998 - 00:00:00 CST