Re: Removing Spaces from Fields

From: Thierry Poels <Thierry.Poels_at_vab.be>
Date: Fri, 20 Aug 1999 11:57:56 +0200
Message-ID: <7pj8r9$4cd$1@news1.skynet.be>

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