Re: Supressing spaces in a field

Michael McGarrigle wrote:
>
> 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

select	'With: '||phoneNo,
	'Without: '||replace(phoneNo,' ') from myTable;

Yours,

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Mon Aug 14 2000 - 21:17:42 CDT