Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Supressing spaces in a field

Supressing spaces in a field

From: Michael McGarrigle <mjm_at_barwonwater.vic.gov.au>
Date: 15 Aug 2000 11:44:16 +1000
Message-ID: <mjm.966303693@fraser>

I have a phone number field which can have values such as the following :

03 9999 1234
111111222222
13 445777777
124 456 77 22

I would like to be able to suppress the space characters in the field.

Does anyone know of some easy way to do this ?

TIA

-- 
Michael McGarrigle   	 mjm_at_barwonwater.vic.gov.au
Information Systems      Barwon Water
61-67 Ryrie St Geelong   Phone: +61 352 262326
Victoria 3220 Australia  Fax:   +61 352 218236
Received on Mon Aug 14 2000 - 20:44:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US