use replace(yourString, " ", "", "ALL")
Chris
Christopher Conrad
Victoria's Secret Catalogue
http://www.VictoriasSecret.com
Senior.Programmer.Analyst
614.337.5653
[EMAIL PROTECTED]
> -----Original Message-----
> From: AustralianAccommodation.com Pty. Ltd.
> [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, July 21, 2000 10:17 AM
> To: [EMAIL PROTECTED]
> Subject: How Eliminate blank spaces between words ??
>
> I need to eliminate the blank spaces between numbers in phone numbers so
> that 07 987 635 can be converted to 07987635
>
> the code needs to read the value in the phone variable from the database
> table and then remove the blank spaces as indicated above
>
> your assistance in this matter would be appreciated
>
>
> Kind Regards
>
> Claude Raiola (Director)
> AustralianAccommodation.com Pty. Ltd.
> Website: www.AustralianAccommodation.com
> Email: [EMAIL PROTECTED]
>
> --------------------------------------------------------------------------
> ----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
