Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Removing Spaces from Fields
Use REPLACE(your_string, ' ', '')
i.e. replace ( your_string, 'one_blank', 'nothing' )
good luck,
Thierry Poels
Oracle DBA & Unix Sysadmin for VTB-VAB NV
dredogg <dredogg_at_bell.net> wrote in message
news:8E0v3.6613$pO3.74934_at_c01read02-admin.service.talkway.com...
> 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).
>
Received on Fri Aug 20 1999 - 04:57:56 CDT