Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Removing Spaces from Fields
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