On removing spaces from string

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Sun, 19 Aug 2001 20:40:29 -0700
Message-ID: <F001.003705F3.20010819205021@fatcity.com>

Hi,
The need is to remove all spaces from a provided string, but if a space exists between two numbers, then it should not be removed. Look at the following examples.

   original string     output required
        XT GB 100 XF 100       XTGB100XF100
        XT GB 123 X F 123      XTGB123XF123
        XT GB 100 100 XF       XTGB100 100XF 

This has to be done in an sql query and not using pl/sql. Is this possible?

rgds
amar
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Amar Kumar Padhi
  INET: TS2017_at_emirates.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Aug 19 2001 - 22:40:29 CDT