Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Removing Spaces from Fields

Re: Removing Spaces from Fields

From: <wasim_ahmed_at_my-deja.com>
Date: Fri, 20 Aug 1999 09:51:32 GMT
Message-ID: <7pj8f3$f15$1@nnrp1.deja.com>


use the function REPLACE like
 select replace(field_name, ' ', '') from table_name regards,
Wasim.

In article <8E0v3.6613$pO3.74934_at_c01read02-admin.service.talkway.com>,   "dredogg" <dredogg_at_bell.net> wrote:
> I have record that contain spaces i.e. (BMS -001)
> I want it to look like: BMS-001. Thanks in Advance
> --
> Posted via Talkway - http://www.talkway.com
> Exchange ideas on practically anything (tm).
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 20 1999 - 04:51:32 CDT

Original text of this message

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