Re: Removing spaces in a field

From: Thomas J Kyte <tkyte_at_us.oracle.com>
Date: 1996/05/10
Message-ID: <31934fd4.1832545_at_dcsun4>#1/1

tony_at_bilpin.co.uk (Tony Desborough) wrote:

update t set x = replace( x, ' ', '' )

will do it.

>
>Hi,
>
>How do I use SQL to remove all spaces from a field ?
>e.g update 'EX 300' to 'EX300'
>
>Please reply via email.
>Thanks in advance
>Tony

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government

---

opinions and statements are mine and do not necessarily reflect the opinions of Oracle Corporation. Received on Fri May 10 1996 - 00:00:00 CEST