Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Supressing spaces in a field
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 218236Received on Mon Aug 14 2000 - 20:44:16 CDT